Re: CommitDatabase vs. CloseDatabase

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39530
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?The don't. Use these contexts according to what you want to achieve. If you want the database to remain open, use commit - otherwise, use close. -- ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Idéer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se------------------------------------------------------------- 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?The don't. Use these contexts according to what you want to achieve. If you want the database to remain open, use commit - otherwise, use close. -- ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Idéer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se------------------------------------------------------------- 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/ Christer Olsson

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:

QuitFeedback & DBNotOpened errors (1997) Separate SSL Server (1997) WebCat2b15MacPlugin - [protect] (1997) corrupted images (2002) WebCommerce Security Alert! (1996) WebCat2b12 forgets serial # (1997) Triggers and today's leap day? (2000) Shipping.db (1998) Purchased cart being overwritten - still !?? (1997) problems with WebCat-Plugin () WebSTAR 2.1 freezes my Mac (1997) Updated ClipText for Edit Plus 2 (2003) [OT] degree symbol (2003) Why is my easy [AddLineItems] NOT working?? (2000) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) Non WebDNA forms and timed popups... (2002) Error Log (2000) POSTing to a secure server ... (2000) 4.0 upgrade pricing (2000) WebStar5 and realm authentication (2003)