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:

Using ticks (2000) Not seeing cart info on Invoice.tmpl (was PROBLEM) (1997) Busted at the Border (1998) includes and cart numbers (1997) Encrypt Decrypt URL UnURL Weirdness (2001) WebCommerce: Folder organization ? (1997) Here's how to kill a Butler Database. (1997) setlineitem quantity to zero? (2000) Thanks ! (1997) Bug Report, maybe (1997) NT Setup (1998) dates and hex formatting (1997) RE: SSL and WebCatalog (1997) Webcat causing crashes left and right! (1997) 'page impression' techniques for banner ads (1999) FW: WebDNA-Talk searchable? (1997) wrong authentication (1998) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) WebCat2b12 CGI Mac - [shownext] problem (1997) Robots fill event log (1997)