Re: make updates in a temporary database

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57644
interpreted = N
texte = 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/ 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)
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/ charles kline

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:

Backwards list behavior ... (1997) Navigator Parsing (1997) port 16080 problem (2003) Copyright that puppy (1998) WebCat2b12 CGI Mac - [shownext] problem (1997) 2.0Beta Command Ref (can't find this instruction) (1997) [OT] Work available (2001) Macauth: Dates and No Scripting... (1997) How to Sort Summ data ? (1997) test (2003) WebCatalog on Linux (2000) Add more fields to an existent data base (1997) Running _every_ page through WebCat-error.html (1997) Close-to Comparison Code (1998) NT Setup (1998) Carts & Refering URLs (1997) PCS Frames (1997) Bug? (1997) Instructions for Digest (1997) [tcp connect] (1998)