Re: make updates in a temporary database

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57646
interpreted = N
texte = Or you're running it off a 20-year-old computer... > From: charles kline > Reply-To: (WebDNA Talk) > Date: Tue, 4 May 2004 20:09:13 -0400 > To: (WebDNA Talk) > Subject: Re: make updates in a temporary database > > 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/ ------------------------------------------------------------- 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)
Or you're running it off a 20-year-old computer... > From: charles kline > Reply-To: (WebDNA Talk) > Date: Tue, 4 May 2004 20:09:13 -0400 > To: (WebDNA Talk) > Subject: Re: make updates in a temporary database > > 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/ ------------------------------------------------------------- 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/ Tim Robinson

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:

DON'T use old cart file! (1997) Help! (1996) European Convention (2004) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Some Questions (1997) [WriteFile] problems (1997) problems with 2 tags (1997) Purchased cart being overwritten - still !?? (1997) Chat Area (2000) [LOOKUP] (1997) RequiredFields template (1997) WebCatalog NT beta 18 now available (1997) Logout? (1998) WebCat and WebTV (1997) [SMSI] WebDNA is too good to go away! (2006) [WebDNA] Base 64 (2010) Adding Multiple Items to Shopping Cart from a Results page (1997) Webcatalog acgi conflict? (1999) Success Stories (1997) Re:[ShowIf] and empty fields (1997)