Re: CommitDatabase vs. CloseDatabase
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39553
interpreted = N
texte = >> >> >Also, it is not necessary to commit a database after EVERY >>>>>modification, unless you have some non-webcat program using the db >>>>>at random and arbitrary times. >>>> >>>>...and if you don't mind losing data in a crash - which was the >>>>starting point for this thread. >>> >>>so turn on autocommit and save yourself some typing. >> >>Yes. If you want to commit every database after every modification. >>Otherwise use commit or close as best suited to your needs - which >>is the bottom line of this thread. If you don't want to learn >>something and understand how to fine tune WebCat, please continue to >>jump to conclusions and drop smart comments. > >Settle down. No offense meant. > >How does turning off autocommit help prevent loosing data in any way?Turning autocommit off does of course not prevent losing data. But that's not the point.Autocommit commits every database after every modification. If you're running a low traffic server with small databases you won't probably notice this very much, but it can slow down a busy server with large databases a *lot*.Also, not every database is probably mission critical, so you can gain some speed by not commit these database as often as you commit your important ones.-- ************************************************************* 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:
>> >> >Also, it is not necessary to commit a database after EVERY >>>>>modification, unless you have some non-webcat program using the db >>>>>at random and arbitrary times. >>>> >>>>...and if you don't mind losing data in a crash - which was the >>>>starting point for this thread. >>> >>>so turn on autocommit and save yourself some typing. >> >>Yes. If you want to commit every database after every modification. >>Otherwise use commit or close as best suited to your needs - which >>is the bottom line of this thread. If you don't want to learn >>something and understand how to fine tune WebCat, please continue to >>jump to conclusions and drop smart comments. > >Settle down. No offense meant. > >How does turning off autocommit help prevent loosing data in any way?Turning autocommit off does of course not prevent losing data. But that's not the point.Autocommit commits every database after every modification. If you're running a low traffic server with small databases you won't probably notice this very much, but it can slow down a busy server with large databases a *lot*.Also, not every database is probably mission critical, so you can gain some speed by not commit these database as often as you commit your important ones.-- ************************************************************* 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:
What am I missing (1997)
Not really WebCat (1997)
[WebDNA] Anchors (2010)
Summing fields (1997)
Database changes (1998)
& in Lookups (1997)
PCS Emailer's role ? (1997)
hmmm (2006)
Country & Ship-to address & other fields ? (1997)
WCS Newbie question (1997)
Apache freak-out with webDNA (2008)
WebCommerce: Folder organization ? (1997)
[WebDNA] The Single-Vendor Commercial Open Source Business Model for WebDNA (2012)
WebCat2 as a chat server? (1997)
SQL Errors (2003)
RE: Nesting [ListFiles] (1998)
I've been thinking (2002)
[append] and SSL (1997)
Date problems-more (1997)
WebCat editing, SiteGuard & SiteEdit (1997)