Re: 100 + Users updating database

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 45879
interpreted = N
texte = About 5 minutes .. > > On Monday, December 2, 2002, at 01:03 PM, Jesse Williams-Proudman> wrote:> >> On 12/2/02 9:21 AM, Jeff Logan wrote:>> >>> Does anyone have recommendations/code for doing a trigger that will>>> roll a copy of the database every four hours.>> >> I do... Though I've put some time into it...> > ok, I'll bite... how much time does it take to write up a simple script> that either> > a) copies the database file on the disk to a duplicate file> or> b) searches the database and writes out all of the found records (i.e.> everything) to a new database file (use the [writefile])> > after that a little triggeriffic goodness, and you're on your way.> > a more complicated method:> You can be like my bank, when someone wants to change a record, it> loads that record on a page. You change and submit, and it saves it as> a new record to the database and lets you review your changes before it> becomes permanent, at which point it keeps the new record and deletes> the previous (and now obsolete) record. Until it's approved via a> review the old record stays active, and you could do a sweep every so> often to get rid of the unfinished record edits.> > > Brian B. Burton> 973-263-3036 973-296-6862 (cell)> BOFH - Department of Redundancy Department> > > -------------------------------------------------------------> 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:

About 5 minutes .. > > On Monday, December 2, 2002, at 01:03 PM, Jesse Williams-Proudman> wrote:> >> On 12/2/02 9:21 AM, Jeff Logan wrote:>> >>> Does anyone have recommendations/code for doing a trigger that will>>> roll a copy of the database every four hours.>> >> I do... Though I've put some time into it...> > ok, I'll bite... how much time does it take to write up a simple script> that either> > a) copies the database file on the disk to a duplicate file> or> b) searches the database and writes out all of the found records (i.e.> everything) to a new database file (use the [writefile])> > after that a little triggeriffic goodness, and you're on your way.> > a more complicated method:> You can be like my bank, when someone wants to change a record, it> loads that record on a page. You change and submit, and it saves it as> a new record to the database and lets you review your changes before it> becomes permanent, at which point it keeps the new record and deletes> the previous (and now obsolete) record. Until it's approved via a> review the old record stays active, and you could do a sweep every so> often to get rid of the unfinished record edits.> > > Brian B. Burton> 973-263-3036 973-296-6862 (cell)> BOFH - Department of Redundancy Department> > > -------------------------------------------------------------> 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/ Alain Russell

DOWNLOAD WEBDNA NOW!

Re: 100 + Users updating database

2002

Top Articles:

Related Readings: