Re: make updates in a temporary database

This WebDNA talk-list message is from

2004

It keeps the original formatting. numero = 57645
interpreted = N
texte = You could make a temporary db and then merge the two databases.This is the code from the default.tpl Merge Databases example from JohnHill.[!]SELECT MASTER DATABASE PAGE[/!][showif [page]=[raw][page][/raw]]

Select the master database (records will merge into this database):
[listfiles ./][showif [filename]^.db][filename][/showif][/listfiles]


[/showif][!]SELECT SECOND DATABASE PAGE[/!][showif [page]=second]

Select the secondary database (records will be copied from thisdatabase):
[listfiles ./][showif [filename]^.db][filename][/showif][/listfiles]


[/showif][!]Map fields between the two[/!][showif [page]=show]

[listfields db=[master]][fieldname] <-- [text]the_field=[fieldname][/text][listfields db=[second]][text]a_field=[fieldname][/text][fieldname][/listfields]
[/listfields]

[/showif][!]Do the merge[/!][showif [page]=merge][search db=[url][second][/url]&ne[a_field]datarq=find_all][numfound] records added to [master] from [second].[founditems][append db=[url][master][/url]][listfieldsdb=[url][master][/url]][text]the_field=[interpret][__[fieldname]][/interpret][/text][hideif[url][the_field][/url]=][fieldname]=[url][interpret][[the_field]][/interpret][/url]&[/hideif][/listfields][/append][/founditems][/search][commitdatabase db=[url][master][/url]][/showif]-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf OfLesterSent: Tuesday, May 04, 2004 4:43 PMTo: WebDNA TalkSubject: make updates in a temporary databaseI 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 toWeb Archive of this list is at: http://webdna.smithmicro.com/__________ NOD32 1.749 (20040503) Information __________This message was checked by NOD32 Antivirus System.http://www.nod32.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:

Re: make updates in a temporary database ( Brian B. Burton 2004) Re: make updates in a temporary database ( Lester 2004) Re: make updates in a temporary database ( Lester 2004) Re: make updates in a temporary database ( Tim Robinson 2004) Re: make updates in a temporary database ( "Sal" 2004) Re: make updates in a temporary database ( charles kline 2004) Re: make updates in a temporary database ( "Gary Krockover" 2004) make updates in a temporary database ( Lester 2004)

You could make a temporary db and then merge the two databases.This is the code from the default.tpl Merge Databases example from JohnHill.[!]SELECT MASTER DATABASE PAGE[/!][showif [page]=[raw][page][/raw]]

Select the master database (records will merge into this database):
[listfiles ./][showif [filename]^.db][filename][/showif][/listfiles]


[/showif][!]SELECT SECOND DATABASE PAGE[/!][showif [page]=second]

Select the secondary database (records will be copied from thisdatabase):
[listfiles ./][showif [filename]^.db][filename][/showif][/listfiles]


[/showif][!]Map fields between the two[/!][showif [page]=show]

[listfields db=[master]][fieldname] <-- [text]the_field=[fieldname][/text][listfields db=[second]][text]a_field=[fieldname][/text][fieldname][/listfields]
[/listfields]

[/showif][!]Do the merge[/!][showif [page]=merge][search db=[url][second][/url]&ne[a_field]datarq=find_all][numfound] records added to [master] from [second].[founditems][append db=[url][master][/url]][listfieldsdb=[url][master][/url]][text]the_field=[interpret][__[fieldname]][/interpret][/text][hideif[url][the_field][/url]=][fieldname]=[url][interpret][[the_field]][/interpret][/url]&[/hideif][/listfields][/append][/founditems][/search][commitdatabase db=[url][master][/url]][/showif]-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf OfLesterSent: Tuesday, May 04, 2004 4:43 PMTo: WebDNA TalkSubject: make updates in a temporary databaseI 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 toWeb Archive of this list is at: http://webdna.smithmicro.com/__________ NOD32 1.749 (20040503) Information __________This message was checked by NOD32 Antivirus System.http://www.nod32.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/ "Sal"

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:

WebCat2 beta 11 - new prefs ... (1997) Nested tags count question (1997) [WebDNA] Version 8 (2014) LOG IN LOG OUT (1997) New WebCatalog site (1997) default value from Lookup (was Grant, please help me) (1997) [WebDNA] Working WebDNA 7 configuration (2011) Re(5): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998) Problems with [Applescript] (1997) Opinion: [input] should be called [output] ... (1997) Lookup question (2001) Db design question (relational vs. flat?) (1998) [format 40s]text[/format] doesn't work (1997) Re:2nd WebCatalog2 Feature Request (1996) webcat- multiple selection in input field (1997) Where is f2? (1997) Big Databases (1997) WebCat2b13MacPlugIn - syntax to convert date (1997) Email within tmpl ? (1997) NT Version on IIS 4.0 (1997)