CommitDatabase vs. CloseDatabase

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39529
interpreted = N
texte = I'm not sure when CommitDatabase should be used instead of CloseDatabase. CloseDatabase will cause all info in RAM to be written to the harddrive. As soon as the database is needed afterwards, the database will be opened and its contents will again be in RAM and available to the templates. If the server crashes, the database will not be lost.CommitDatabase writes the info in RAM to the harddrive, but does not close the database. Again, if the server crashes, the database will not be lost.If I have this right, why would one protect a database better than the other?Glenn------------------------------------------------------------- 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:

    
  1. Re: CommitDatabase vs. CloseDatabase (Christer Olsson 2001)
  2. Re: CommitDatabase vs. CloseDatabase (Samuel Renkert 2001)
  3. Re: CommitDatabase vs. CloseDatabase (Christer Olsson 2001)
  4. Re: CommitDatabase vs. CloseDatabase (Samuel Renkert 2001)
  5. Re: CommitDatabase vs. CloseDatabase (Christer Olsson 2001)
  6. Re: CommitDatabase vs. CloseDatabase (Glenn Busbin 2001)
  7. Re: CommitDatabase vs. CloseDatabase (Samuel Renkert 2001)
  8. Re: CommitDatabase vs. CloseDatabase (Grant Hulbert 2001)
  9. Re: CommitDatabase vs. CloseDatabase (Alex McCombie 2001)
  10. Re: CommitDatabase vs. CloseDatabase (Glenn Busbin 2001)
  11. Re: CommitDatabase vs. CloseDatabase (Glenn Busbin 2001)
  12. Re: CommitDatabase vs. CloseDatabase (Samuel Renkert 2001)
  13. Re: CommitDatabase vs. CloseDatabase (Nitai @ ComputerOil 2001)
  14. Re: CommitDatabase vs. CloseDatabase (Nitai @ ComputerOil 2001)
  15. Re: CommitDatabase vs. CloseDatabase (Christer Olsson 2001)
  16. CommitDatabase vs. CloseDatabase (Glenn Busbin 2001)
I'm not sure when CommitDatabase should be used instead of CloseDatabase. CloseDatabase will cause all info in RAM to be written to the harddrive. As soon as the database is needed afterwards, the database will be opened and its contents will again be in RAM and available to the templates. If the server crashes, the database will not be lost.CommitDatabase writes the info in RAM to the harddrive, but does not close the database. Again, if the server crashes, the database will not be lost.If I have this right, why would one protect a database better than the other?Glenn------------------------------------------------------------- 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/ Glenn Busbin

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:

[WriteFile] problems (1997) Multiple Pulldowns (1997) Another Large Database Questions (1997) [WebDNA] WebDNA FastCGI (2012) [date format] w/in sendmail (1997) Help! WebCat2 bug (1997) Cookies (1999) shipcost (1997) Question about replacing words (1998) WebDNA Solutions --> Date format suggestions (1998) textarea input- nevermind (2002) {Grouping} Docs (1999) Email Newsletters (2003) WebCat/CyberStudio Compatibility (1998) Interesting speed comparison .. (2003) Search/sort in URL Was: GuestBook example (1997) Follow-up to listfiles bug report ... (2003) Calculating multiple shipping... (1997) Major bug report on rootbeer (1997) Clickable maps and WebCatalog? (1996)