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 = 106227
interpreted = N
texte = --Boundary-01=_HRvRNBzhuSHNV7E Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit > 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 --Boundary-01=_HRvRNBzhuSHNV7E Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit

> 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

--Boundary-01=_HRvRNBzhuSHNV7E-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Hard-coded db write delay when running certain code? (christophe.billiottet@webdna.us 2011)
  2. [WebDNA] Hard-coded db write delay when running certain code? (Kenneth Grome 2011)
--Boundary-01=_HRvRNBzhuSHNV7E Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit > 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 --Boundary-01=_HRvRNBzhuSHNV7E Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit

> 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

--Boundary-01=_HRvRNBzhuSHNV7E-- 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:

[isfile] ? (1997) Url encoded fun (1998) PhotoMill -> PhotoMaster (1997) ReadDateFormat bug in 3.x (1998) Add to Cart & List of Products (1997) Can WC remember people? (1998) SSL and reg web* (1997) best way to test for the existence of a parameter in a url (2003) formula??? (2000) European Convention (2004) Cancel Subscription (1996) WebCatalog Prefs.ref file ? (1998) Webcat2, WebCommerce, Mod 10 etc. (1997) CommitDatabase vs. CloseDatabase (2001) http upload (2001) Authenticate (1997) Accessing SQL server from OSX (2001) Separate SSL Server (1997) Extended [ConvertChars] (1997) [OT] grep help (2004)