make updates in a temporary database
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57642
interpreted = N
texte = I have a site where making to the changes during"peak" periods causes my admin functions to basicallygo 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-peakperiods, so that can't be the solution.I'm thinking that when I'm making changes to thedatabase, and people are accessing this same databaseduring 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.5Thanks__________________________________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:
I have a site where making to the changes during"peak" periods causes my admin functions to basicallygo 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-peakperiods, so that can't be the solution.I'm thinking that when I'm making changes to thedatabase, and people are accessing this same databaseduring 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.5Thanks__________________________________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:
HELP WITH DATES (1997)
include bug????? (1997)
[carts] and databases (1997)
WC2.0 Memory Requirements (1997)
Quit revisited (1997)
[accountNum] and [math] (1997)
One other big addition... (1997)
Clear/Reset form with JavaScript (2001)
FREE Web Server Monitor FREE (1997)
Statistics... (2004)
math on date? (1997)
Anyone here care to chime in? (2005)
(2000)
Requiring that certain fields be completed (1997)
Forbidden CGI Error (1997)
authorizenet and netscape (2002)
[SearchString] usage (1997)
OT - asp snippet similar to [!][/!] (2003)
upgrading to windows 2000 (2001)
Online reference (1997)