lockup db's

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 29921
interpreted = N
texte = 03/31/00 06:37:30 deadlocked :www.mydomain.com:databases:hits.db, 29178060 times waiting for writeWhat exactly is causing this, I have an operation that does this[replace db=hits.db&equiddata=[x]]hits=[math][lookup db=hits&returnfield=hits]+1[/math][/replace]If I logged the hits like this instead: [append db=hits.db][thisurl] [date] [time][/append]would I still get the errors?Would I be better off:[spawn] [append db=hits.db][thisurl] [date] [time][/append] [/spawn]Would this still log the hit and let my browser load data without even a tick of waiting, this server is under heavy load.Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, Unix, and AS/400. ------------------------------------------------------------- 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 Associated Messages, from the most recent to the oldest:

    
  1. lockup db's (Bob Minor 2000)
03/31/00 06:37:30 deadlocked :www.mydomain.com:databases:hits.db, 29178060 times waiting for writeWhat exactly is causing this, I have an operation that does this[replace db=hits.db&equiddata=[x]]hits=[math][lookup db=hits&returnfield=hits]+1[/math][/replace]If I logged the hits like this instead: [append db=hits.db][thisurl] [date] [time][/append]would I still get the errors?Would I be better off:[spawn] [append db=hits.db][thisurl] [date] [time][/append] [/spawn]Would this still log the hit and let my browser load data without even a tick of waiting, this server is under heavy load.Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, Unix, and AS/400. ------------------------------------------------------------- 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 Bob Minor

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:

OFF-TOPIC: Check www.godaddy.com for me ... (2003) Nesting format tags (1997) Trouble with Category search (2000) 5.0 feature request: Multiple Server Support (2001) Wanted: Broader string manipulation functions (1997) RE: PIXO support (1997) Error handling for accountNum (1997) [TaxableTotal] - not working with AOL and IE (1997) Fun with Dates - finally resolved but.... (1997) Auto Delete EmailCompleted Files (2002) Databases inside [SHOWIF] (1998) Shipping charge question (2003) PCS Emailer's role ? (1997) Only charge card when product shipped ? (1997) Installing WebDNA on Linux (2007) [WebDNA] [writefile] to MailFolder instead of using sendmail? (2017) upgrading (1997) formulas.db (1999) WebCat 3!!! (2000) Re:affiliate marketing program (1998)