Re: CloseDataBase vs CommitDataBase
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 68841
interpreted = N
texte = > I would suspect that closedatabases could cause more of a > performance hit (in performance intense situations) than > commitdatabases. > My reasoning is because commitdatabase is not taking the .db out of > RAM. That is correct; however it is a known issue with WebDNA 4.5.1 WebSTAR plugin version that multiple instances of the same database can be opened. This results in one instance being written to the disk when modified, but the other instance is still opened in ram, and contains outdated info. The only solution is to close all databases, and reopen them from disk. I know it then has to be reloaded into RAM, but there is no other option (aside from upgrading - hopefully the problem has been fixed in the latest version). > I use [commitdatabase..] *after* ever append/replace/delete out of > habbit. Theoretically, you shouldn't even have to do this - WebDNA should do this automatically if the option is set in the preferences. Dennis ------------------------------------------------------------- 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:
> I would suspect that closedatabases could cause more of a > performance hit (in performance intense situations) than > commitdatabases. > My reasoning is because commitdatabase is not taking the .db out of > RAM. That is correct; however it is a known issue with WebDNA 4.5.1 WebSTAR plugin version that multiple instances of the same database can be opened. This results in one instance being written to the disk when modified, but the other instance is still opened in ram, and contains outdated info. The only solution is to close all databases, and reopen them from disk. I know it then has to be reloaded into RAM, but there is no other option (aside from upgrading - hopefully the problem has been fixed in the latest version). > I use [commitdatabase..] *after* ever append/replace/delete out of > habbit. Theoretically, you shouldn't even have to do this - WebDNA should do this automatically if the option is set in the preferences. Dennis ------------------------------------------------------------- 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/
"Dennis J. Bonsall, Jr."
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:
[WebDNA] Count Lines (2011)
WebDNA versus ASP [OT] (2002)
WebCat2b15MacPlugin - showing [math] (1997)
Upgrading old WebCat Database Files (1997)
Max Record length restated as maybe bug (1997)
Replace Statement (1997)
Serious bug writing to a database ... (2002)
Press Release hit the NewsWire!!! (1997)
WebCatalog on Linux (2000)
Dynamic Pop up menu? (1997)
Re1000001: Setting up shop (1997)
[math date]: Arrrggh! (2003)
Location of Browser Info.txt file (1997)
Problem with [Search] inside of [Loop]? (1997)
WC1.6 to WC2 date formatting (1997)
Hiding HTML and page breaks (1997)
Reading through the Order File (1999)
[WebDNA] [OT] Sorry just some email issues (2018)
The force has left me. (2002)
Emailer kaput? (2000)