Re: Temp DB (Was freeze)
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47651
interpreted = N
texte = On 2/10/03 10:31 PM, Alain Russell
wrote:> We run a huge number of databases/high traffic and never have a freeze/pause > .. Unless Andrew is tinkering with something ;) Well suffice to say, that I believe any search on a large db using webstar & sys 9.x that takes 5-10 seconds (and is not in a spawn style context) will cause the server to pause for those 5 seconds... Or to some degree. I have seen large operations (like the 150 second one I did tonight) relinquish some cycles to let the server _try_ and pretend like it is serving happily (spurts every 5-10 seconds or so), but that's about it.I just didn't know I had a 8 second search happening on a very popular set of DBs.I always hate how these threads I start degrade into tangents ;-)Leaves me with list guilt :-OAlexAlex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
On 2/10/03 10:31 PM, Alain Russell wrote:> We run a huge number of databases/high traffic and never have a freeze/pause > .. Unless Andrew is tinkering with something ;) Well suffice to say, that I believe any search on a large db using webstar & sys 9.x that takes 5-10 seconds (and is not in a spawn style context) will cause the server to pause for those 5 seconds... Or to some degree. I have seen large operations (like the 150 second one I did tonight) relinquish some cycles to let the server _try_ and pretend like it is serving happily (spurts every 5-10 seconds or so), but that's about it.I just didn't know I had a 8 second search happening on a very popular set of DBs.I always hate how these threads I start degrade into tangents ;-)Leaves me with list guilt :-OAlexAlex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Alex McCombie
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:
[OT] Server check please (2006)
[append] and SSL (1997)
WebCat2 several catalogs? (1997)
form data submission gets truncated (1997)
Textarea Breaks (2000)
frames & carts (1997)
WebCatalog Features (1997)
sendmail spaces (1997)
[math] error (2000)
[WebDNA] [url] broken inside [setcookie], on a square-bracket-style (2009)
Printing a final order (1997)
Re:2nd WebCatalog2 Feature Request (1996)
$append (1998)
WebCatalog Hosting (1996)
idear about how to get SMSI to speak. (2006)
Printing a final order (1997)
dont want to use credit card authorisation yet (2000)
enhanced ErrorMessages.db (2002)
Bcc in sendmail tag (2000)
How true is this? (1999)