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. GK On 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:

    
  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)
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. GK On 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)