Re: CommitDatabase vs. CloseDatabase
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39536
interpreted = N
texte = On 10/23/01 1:31 PM, Glenn Busbin
wrote:> Right, but if WC opens a db when it's needed, there's no reason to use > CommitDatabase, is there? > > I must be overlooking some advantage to using Commitdatabase. Simple answer....Assume 2 db's. First one is 100k, Second is 50 megs. On 100k file, either will work fine and you will probably not notice any difference in performance.The 50 meg one...well. Make Webcat write to the file and then close it, only to have it open at the next occurrence would certainly cause performance issues. While writing to the HD would be bad enough without the need to reopen it a few minutes later. So while the numbers above are extreme, in those situations it would make a huge difference in performance if not data integrity.Hope this helps. AlexAlex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
On 10/23/01 1:31 PM, Glenn Busbin wrote:> Right, but if WC opens a db when it's needed, there's no reason to use > CommitDatabase, is there? > > I must be overlooking some advantage to using Commitdatabase. Simple answer....Assume 2 db's. First one is 100k, Second is 50 megs. On 100k file, either will work fine and you will probably not notice any difference in performance.The 50 meg one...well. Make Webcat write to the file and then close it, only to have it open at the next occurrence would certainly cause performance issues. While writing to the HD would be bad enough without the need to reopen it a few minutes later. So while the numbers above are extreme, in those situations it would make a huge difference in performance if not data integrity.Hope this helps. AlexAlex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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://search.smithmicro.com/
Alex McCombie
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:
Logging purchases (1997)
Separate SSL Server (1997)
upgrading (1997)
same bill to and ship to? (1998)
Error Log.db --however (1997)
rotating thumbnails (1997)
Press Release hit the NewsWire!!! (1997)
Heads up, cookies *may* be outlawed in Europe (2001)
Feature request for next version (2005)
[OT] Invoking a MP3 Download (2004)
Locking up with WebCatalog... (1997)
[ShowNext] feature in 2.0 (1997)
Looking up two prices in Formulas.db (1997)
funky character (2002)
Browser Problem?!? Still getting Error message using POST! (1997)
WC1.6 to WC2 date formatting (1997)
[returnraw] and form variables (1998)
Stat analyzer (1997)
Redirect (2003)
&max= (2003)