Re: make updates in a temporary database
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57643
interpreted = N
texte = What kind of changes are you making to the database? If you have a duplicate db, any records that are added/modified between the time you take a snapshot (duplicate) and upload that version will not be present - you'll lose those changes obviously.IMO, it's always best to use WebDNA to make your changes to a db if at all possible. I do get into the actual db's when absolutely needed, and only then it's late hours and very briefly. If it takes longer than 10 minutes, I shut down the site. These are very rare and extreme cases. I then then commit the db's right afterwards (or flushdb's). Are you flushing or committing the db's after modifications? Perhaps that is the cause of the slowdown.GKOn Tue, 4 May 2004 16:42:36 -0700 (PDT) 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-------------------------------------------------------------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:
What kind of changes are you making to the database? If you have a duplicate db, any records that are added/modified between the time you take a snapshot (duplicate) and upload that version will not be present - you'll lose those changes obviously.IMO, it's always best to use WebDNA to make your changes to a db if at all possible. I do get into the actual db's when absolutely needed, and only then it's late hours and very briefly. If it takes longer than 10 minutes, I shut down the site. These are very rare and extreme cases. I then then commit the db's right afterwards (or flushdb's). Are you flushing or committing the db's after modifications? Perhaps that is the cause of the slowdown.GKOn Tue, 4 May 2004 16:42:36 -0700 (PDT) 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-------------------------------------------------------------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/
"Gary Krockover"
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:
Practice runs ? (1997)
list items (1998)
Newbie Help Needed (1998)
Visitor info (2000)
Cookies and WebCat?? (1999)
Quantity * price (1997)
greater than or equal to (1997)
[WebDNA] Error 500 with SUMM=T (2017)
[WebDNA] Video Request: "Faces of WebDNA" (2010)
4.5 Upgrade (2003)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Text data with spaces in them... (1997)
WebCat cannot handle compatible search parameters? (1997)
How can I record purchases to a database? (1998)
Shipcost lookup? (1997)
Adding multiple items to Cart at one time, & append contextproblem (1998)
Database Options (1997)
Pull Down Search (2000)
WebCat cannot handle compatible search parameters? (1997)
Listserver problem (1997)