Re: make updates in a temporary database

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57649
interpreted = N
texte = [commitdatabase db=products.db] is used in my admin when I update the database after making a change to it. would [flushdatabases]be a better choice here? I also was looking in the webdna preferences and saw that there is a line: Seconds to wait for busy database = 20 the explaination of (from admin help): Prevents database deadlock by only waiting a certain amount of time before "giving up" on an exclusive lock of a database. would changing this item help any ? --- Lester wrote: > The slowdown in the admin side only occurs when the > site has heavy access, making me think that while > I'm > "updating" the .db and many others are also trying > to > "view" that same .db, some issue of who's first > occurs > . . . > > All is well and has always been well during periods > when access to the website is not that heavy . . . > > The admin is made from the vers. 4.5 storebuilder > code. > > I'll look at the code and see if I'm flushing db's > > > > --- charles kline wrote: > > I am wondering why you are seeing the slowdown. > 2MB > > is nothing for a > > db. We make modifications to 800MB databases > > regularly (using WebDNA) > > and never have any problems. > > > > Maybe your code could be optimized?? > > > > - Charles > > > > On May 4, 2004, at 7:42 PM, Lester wrote: > > > > > I have a site where making to the changes during > > > "peak" periods causes my admin functions to > > basically > > > go s-l-o-w or the admin pages freeze up it > seems. > > > > > > Only during these peak user periods. > > > > > > It's not practicle to make changes during > off-peak > > > periods, so that can't be the solution. > > > > > > I'm thinking that when I'm making changes to the > > > database, and people are accessing this same > > database > > > during this period, that's when my issue > appears. > > > > > > It's not a large database, maybe 2 megs or so. > > > > > > I was thinking working on an exact duplicate of > > the > > > "live" database and then when changes are done > > > "swapping" the worker version with the "live > > version. > > > > > > Anyone doing something like this?? > > > > > > How did you approach it all codewise? > > > > > > > > > I'm still using vers 4.5 > > > > > > Thanks > > > > > > > > > > > > > > >  > > >  > > > __________________________________ > > > Do you Yahoo!? > > > Win a $20,000 Career Makeover at Yahoo! HotJobs > > > > > > http://hotjobs.sweepstakes.yahoo.com/careermakeover > > > > > > > > > ------------------------------------------------------------- > > > 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/ > > > > > > > > > > ------------------------------------------------------------- > > 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/ > > > >  >  > __________________________________ > Do you Yahoo!? > Win a $20,000 Career Makeover at Yahoo! HotJobs > http://hotjobs.sweepstakes.yahoo.com/careermakeover > > ------------------------------------------------------------- > 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/   __________________________________ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover ------------------------------------------------------------- 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:

    
  1. Re: make updates in a temporary database ( Brian B. Burton 2004)
  2. Re: make updates in a temporary database ( Lester 2004)
  3. Re: make updates in a temporary database ( Lester 2004)
  4. Re: make updates in a temporary database ( Tim Robinson 2004)
  5. Re: make updates in a temporary database ( "Sal" 2004)
  6. Re: make updates in a temporary database ( charles kline 2004)
  7. Re: make updates in a temporary database ( "Gary Krockover" 2004)
  8. make updates in a temporary database ( Lester 2004)
[commitdatabase db=products.db] is used in my admin when I update the database after making a change to it. would [flushdatabases]be a better choice here? I also was looking in the webdna preferences and saw that there is a line: Seconds to wait for busy database = 20 the explaination of (from admin help): Prevents database deadlock by only waiting a certain amount of time before "giving up" on an exclusive lock of a database. would changing this item help any ? --- Lester wrote: > The slowdown in the admin side only occurs when the > site has heavy access, making me think that while > I'm > "updating" the .db and many others are also trying > to > "view" that same .db, some issue of who's first > occurs > . . . > > All is well and has always been well during periods > when access to the website is not that heavy . . . > > The admin is made from the vers. 4.5 storebuilder > code. > > I'll look at the code and see if I'm flushing db's > > > > --- charles kline wrote: > > I am wondering why you are seeing the slowdown. > 2MB > > is nothing for a > > db. We make modifications to 800MB databases > > regularly (using WebDNA) > > and never have any problems. > > > > Maybe your code could be optimized?? > > > > - Charles > > > > On May 4, 2004, at 7:42 PM, Lester wrote: > > > > > I have a site where making to the changes during > > > "peak" periods causes my admin functions to > > basically > > > go s-l-o-w or the admin pages freeze up it > seems. > > > > > > Only during these peak user periods. > > > > > > It's not practicle to make changes during > off-peak > > > periods, so that can't be the solution. > > > > > > I'm thinking that when I'm making changes to the > > > database, and people are accessing this same > > database > > > during this period, that's when my issue > appears. > > > > > > It's not a large database, maybe 2 megs or so. > > > > > > I was thinking working on an exact duplicate of > > the > > > "live" database and then when changes are done > > > "swapping" the worker version with the "live > > version. > > > > > > Anyone doing something like this?? > > > > > > How did you approach it all codewise? > > > > > > > > > I'm still using vers 4.5 > > > > > > Thanks > > > > > > > > > > > > > > >  > > >  > > > __________________________________ > > > Do you Yahoo!? > > > Win a $20,000 Career Makeover at Yahoo! HotJobs > > > > > > http://hotjobs.sweepstakes.yahoo.com/careermakeover > > > > > > > > > ------------------------------------------------------------- > > > 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/ > > > > > > > > > > ------------------------------------------------------------- > > 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/ > > > >  >  > __________________________________ > Do you Yahoo!? > Win a $20,000 Career Makeover at Yahoo! HotJobs > http://hotjobs.sweepstakes.yahoo.com/careermakeover > > ------------------------------------------------------------- > 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/   __________________________________ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover ------------------------------------------------------------- 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/ Lester

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:

syntax question, not in online refernce (1997) WebCat & WebTen (1997) Ram usage (1999) hideif glitch (2003) selecting multiple found items (1997) Credit Card Checksum (1997) Replace context problem ... and answers (1997) too many nested tags ... (1997) authenticate broken when url not fully specified? (2000) Revisit: speed test (2002) Formatting of email on NT (1998) Testing the WebCat Email List Members (2000) Webcatalog error, Plug-in for Webstar (1996) Download Question (1997) Code database (1998) Problems with [Search] param - Mac Plugin b15 (1997) [WebDNA] WebDNA and MariaDB (2019) Obtaining a dice result (2007) New Plug-in and Type 11 errors (1997) Error Log with Linux? (2000)