Re: [WebDNA] Some code inside a large loops fail ... but why?
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 104446
interpreted = N
texte = > > I really don't understand why webdna failed to write > > to the db when I set the number of iterations to > > 10,000 and I cannot explain why the network activity > > continued (which means data was being received) > > but the database writing failed. This is the the > > mystery that bothers me more than anything else > > because it suggests a bigger underlying problem > > that may be unusually difficult to diagnose. > > It's very possible you're trying to open too many sockets. > You should probably try to code defensively, and first > check the incoming data before trying to write the data > to your database. I think it is impossible that I was trying to open too many sockets ... My code was opening one connection at a time, then sending the request, then receiving the request, then closing the connection -- all before the next connection was opened. How could this possibly try to open too many sockets? I observed the sequential character of the connections in my network monitor. But even though the data was being requested and received one connection at a time, the replace context was NOT writing the received data to the db like it should have been. Sincerely, Kenneth Grome www.KenGrome.com > > Best, > Christer > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 >
Associated Messages, from the most recent to the oldest:
> > I really don't understand why webdna failed to write > > to the db when I set the number of iterations to > > 10,000 and I cannot explain why the network activity > > continued (which means data was being received) > > but the database writing failed. This is the the > > mystery that bothers me more than anything else > > because it suggests a bigger underlying problem > > that may be unusually difficult to diagnose. > > It's very possible you're trying to open too many sockets. > You should probably try to code defensively, and first > check the incoming data before trying to write the data > to your database. I think it is impossible that I was trying to open too many sockets ... My code was opening one connection at a time, then sending the request, then receiving the request, then closing the connection -- all before the next connection was opened. How could this possibly try to open too many sockets? I observed the sequential character of the connections in my network monitor. But even though the data was being requested and received one connection at a time, the replace context was NOT writing the received data to the db like it should have been. Sincerely, Kenneth Grome www.KenGrome.com > > Best, > Christer > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 >
Kenneth Grome
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Blasted shownext (request for 4.0) (1998)
Disappearing Inventory (2003)
WebDNA (WebCatalog) working with iTools 7.3 (2004)
SSL and reg web* (1997)
WebDelivery: One step closer !! (1997)
[WebDNA] Connect to MS SQL (2013)
Summing fields (1997)
[WebDNA] webdna.us (2008)
Looking for WebDNA 3.08 MAC (2003)
Deleting Multiple Database Records based on Checkbox (1998)
[WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011)
Erotic Sites (1997)
Using Plug-In while running 1.6.1 (1997)
autosensing lanague selection (1997)
WebCat2 - [format thousands] (1997)
XML - USPS Lookups - UPS Lookups (2003)
WebCatalog can't find database (1997)
Multiple cart additions (1997)
re: [addlineitem] working almost (1997)
woops - speed results - right subject (2002)