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:

Sendmail Excel attachment (2003) OSX Jaguar, 4.5 and iTools 6.5 (2002) WCS Newbie question (1997) Cross domains Shopping Carts (2003) Speed questions (1998) problems with 2 tags (1997) Problem 2: Prefs file... (1997) WebCatalog [FoundItems] Problem - AGAIN - (1997) Another bug to squash (WebCat2b13 Mac .acgi) (1997) &FieldNametype=time unnecessary? (2000) Erotic Sites (1997) Image Upload and Auto Resize? (2003) How To question on setting up downloads (1997) Secure Server (1999) Where is the bug fix info for 4.0.1? (2000) Setting up shop (1997) [Off] Netscape Display Problem (1998) ListFiles (1998) Safari cookies (2006) [SearchString] problem with [search] context (1997)