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??- CharlesOn 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:
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??- CharlesOn 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:
emailer (1997)
Alternative colors? - Thanks! (2000)
Redirect in 4.0 (2000)
FYI-WebCat Mac or NT (1997)
File Upload (1997)
Sku numbers (1997)
A dynamic database. (1997)
CSV import suggestions (2007)
CMS (2003)
moved shoppingCarts folder... now there's nothing in it. (2001)
Date Sorting (1997)
Speed Optimization - Mac (1997)
TCP connect, how long does it take (PCS please) (1999)
WebCat2.0 acgi vs plugin (1997)
FlushDatabase Suggestion (1998)
Re:Emailer and encryption (1997)
FORMS: Returning a specific page (1997)
Promise of future help (1998)
WebCat2b15MacPlugin - [protect] (1997)
Unique SKU Numbers (2000)