Re: CloseDataBase vs CommitDataBase

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 68842
interpreted = N
texte = Dennis J. Bonsall, Jr. wrote: >> 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 Yes indeed, but I have heard similar statements as yours regarding this over the years (commitdatabase not working all the time).. and at some point I just starting coding this way.. (for the "just in case" scenerio). Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Desktop Publishing, Print Consulting, Labels -> <-Glass Products, off-hand Classes/studio rental-> PH:> (608) 835-2476 | Forum:> http://egg.bz/forum/ Web Sites:> http://www.euca.us & http://www.egg.bz =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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: CloseDataBase vs CommitDataBase ( Terry Wilson 2007)
  2. Re: CloseDataBase vs CommitDataBase ( thierry 2007)
  3. Re: CloseDataBase vs CommitDataBase ( Donovan Brooke 2007)
  4. Re: CloseDataBase vs CommitDataBase ( "Dennis J. Bonsall, Jr." 2007)
  5. Re: CloseDataBase vs CommitDataBase ( "Dennis J. Bonsall, Jr." 2007)
  6. Re: CloseDataBase vs CommitDataBase ( Lester 2007)
  7. Re: CloseDataBase vs CommitDataBase ( Donovan Brooke 2007)
  8. Re: CloseDataBase vs CommitDataBase ( "Dennis J. Bonsall, Jr." 2007)
  9. Re: CloseDataBase vs CommitDataBase ( Donovan Brooke 2007)
  10. Re: CloseDataBase vs CommitDataBase ( Donovan Brooke 2007)
  11. Re: CloseDataBase vs CommitDataBase ( "Dennis J. Bonsall, Jr." 2007)
  12. Re: CloseDataBase vs CommitDataBase ( Lester 2007)
  13. Re: CloseDataBase vs CommitDataBase ( "Dennis J. Bonsall, Jr." 2007)
  14. CloseDataBase vs CommitDataBase ( Lester 2007)
Dennis J. Bonsall, Jr. wrote: >> 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 Yes indeed, but I have heard similar statements as yours regarding this over the years (commitdatabase not working all the time).. and at some point I just starting coding this way.. (for the "just in case" scenerio). Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Desktop Publishing, Print Consulting, Labels -> <-Glass Products, off-hand Classes/studio rental-> PH:> (608) 835-2476 | Forum:> http://egg.bz/forum/ Web Sites:> http://www.euca.us & http://www.egg.bz =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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/ Donovan Brooke

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] why is this cookie being set to expire at end of browser session? (2009) TeaRoom Order fields email account remain empty even though thewy are filled. (1997) Date Sorting (1997) WebCat2 beta 11 - new prefs ... (1997) [ConvertChars] problem (1997) Updating fields from different platforms (1998) [WebDNA] showif with empty variable (2015) Canadian Credit Card processing co, from a Mac (2001) WebMerchant Error (1998) Dynamic Form - Shipping Country / State/ Province (2006) [BULK] [WebDNA] Happy St. Patricks Day WEBDNA (2018) WC Database Format (1997) Exists? (1997) Protect vs Authenicate (1997) WebDNA-Talk Digest mode broken (1997) Help name our technology! (1997) Images do not upload completely ... (2003) Extended [ConvertChars] (1997) WebCatalog can't find database (1997) Summing fields (1997)