Re: [WebDNA] Re: Hard-coded db write delay when running certain code?
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106229
interpreted = N
texte = I just tried again and quickly did a copy of the cookie (this time=20[/!]Cookie: wpid=3D%2D101&id=3D1136&cookies=3Dtrue; =ASPSESSIONIDSSDRADTD=3DMCCLABFDBGKNJAAHIFIJMLIO; =ASPSESSIONIDSSDRADTD=3DMCCLABFDBGKNJAAHIFIJMLIO[crlf][!]and reloaded the page almost immediately: i got the same[grabbed] with your js time counter and nothing else, for several =minutes.I would not be able to check your code but i am pretty sure it comes =neither from [append] nor [tcpconnect]. I will retest tcpconnect and =double check the timeout.- chrisOn Jan 31, 2011, at 15:41, Kenneth Grome wrote:> > To me, it sounds like a tcpconnect timeout (150 seconds)> So far this seems to make more sense than any other theory, except =that it's a 140 second interval between db writes, not 150 seconds. Are =you sure that WebDNA's tcpconnect timeout is 150 seconds?> I guess it is possible that the tcpconnect receives all the data from =the remote server in 1-2 seconds, then it just sits there for the next =138-139 seconds waiting for the timeout to expire before writing to the =db. This might very well cause the timestamps to be exactly 140 seconds =apart given the way my code is written and runs.> Note that I've tried running my code with (and without) keep-alive =enabled and it does the same thing either way, so I don't think that the =keep-alive header is keeping the connection open that long. Keep-alive =is only set to 115 and that's shorter than tcpconnect's 150 (or 140) =second timeout ... so it looks like the connection is being held open by =WebDNA.> But my tcpconnect headers are the exact same headers that Firefox is =sending when I request the remote page manually in my browser, so =theoretically the remote server cannot tell the difference between my =Firefox requests and WebDNA's tcp requests. Yet something is causing =the 140 second delay I'm seeing when I run my tcpconnect, and no such =delay is present when I use Firefox directly, so clearly there *IS* a =difference between Firefox and tcpconnect. I'm just not sure what it is =at this point ...> :(> I just looked at the online docs and unfortunately I don't see any way =to change the default tcpconnect timeout. Is there an optional =parameter for the tcpconnect timeout that is undocumented? If so I =could try to override tcpconnect's built-in 150 second timeout, and if =the "time between appends" changes along with the timeout change, I =think we can be relatively certain that this problem comes from WebDNA's =tcpconnect timeout ...> Sincerely,> Kenneth Grome> --------------------------------------------------------- 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 Bug =Reporting:support@webdna.us
Associated Messages, from the most recent to the oldest:
I just tried again and quickly did a copy of the cookie (this time=20[/!]Cookie: wpid=3D%2D101&id=3D1136&cookies=3Dtrue; =ASPSESSIONIDSSDRADTD=3DMCCLABFDBGKNJAAHIFIJMLIO; =ASPSESSIONIDSSDRADTD=3DMCCLABFDBGKNJAAHIFIJMLIO[crlf]
[!]and reloaded the page almost immediately: i got the same[grabbed] with your js time counter and nothing else, for several =minutes.I would not be able to check your code but i am pretty sure it comes =neither from
[append] nor
[tcpconnect]. I will retest tcpconnect and =double check the timeout.- chrisOn Jan 31, 2011, at 15:41, Kenneth Grome wrote:> > To me, it sounds like a tcpconnect timeout (150 seconds)> So far this seems to make more sense than any other theory, except =that it's a 140 second interval between db writes, not 150 seconds. Are =you sure that WebDNA's tcpconnect timeout is 150 seconds?> I guess it is possible that the tcpconnect receives all the data from =the remote server in 1-2 seconds, then it just sits there for the next =138-139 seconds waiting for the timeout to expire before writing to the =db. This might very well cause the timestamps to be exactly 140 seconds =apart given the way my code is written and runs.> Note that I've tried running my code with (and without) keep-alive =enabled and it does the same thing either way, so I don't think that the =keep-alive header is keeping the connection open that long. Keep-alive =is only set to 115 and that's shorter than tcpconnect's 150 (or 140) =second timeout ... so it looks like the connection is being held open by =WebDNA.> But my tcpconnect headers are the exact same headers that Firefox is =sending when I request the remote page manually in my browser, so =theoretically the remote server cannot tell the difference between my =Firefox requests and WebDNA's tcp requests. Yet something is causing =the 140 second delay I'm seeing when I run my tcpconnect, and no such =delay is present when I use Firefox directly, so clearly there *IS* a =difference between Firefox and tcpconnect. I'm just not sure what it is =at this point ...> :(> I just looked at the online docs and unfortunately I don't see any way =to change the default tcpconnect timeout. Is there an optional =parameter for the tcpconnect timeout that is undocumented? If so I =could try to override tcpconnect's built-in 150 second timeout, and if =the "time between appends" changes along with the timeout change, I =think we can be relatively certain that this problem comes from WebDNA's =tcpconnect timeout ...> Sincerely,> Kenneth Grome> --------------------------------------------------------- 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 Bug =Reporting:support@webdna.us
christophe.billiottet@webdna.us
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:
upgrading (1997)
how to deal with xml exported file (2007)
Converting Quotes in Javascript (2001)
File dates in WebCatalog .tmpl/.inc (1997)
What's the mod_webcatalog2.so.2.0 file for??? (2005)
Too Much Rootbeer Free Offer (1997)
Formatted [time] inside sendmail (2002)
Banner ads (2000)
with Link i need to (1997)
Generating Report Totals (1997)
Looking up two prices in database? (1997)
What is WebDNA (1997)
WebCat2 several catalogs? (1997)
[OT] Multihoming Windows 2003 Server (2005)
What am I missing (1997)
Limits (2000)
wrong input values? (1997)
HELP WITH DATES (1997)
Re:upgrade problem with users.db (1998)
Generating Report Totals (1997)