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:
[WebDNA] An apache config file that works? (2013)
Disappearing Databases (2000)
validatin on NT (sorry for the dups and etc) (1998)
Search/sort in URL Was: GuestBook example (1997)
WebCat2 several catalogs? (1997)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
when is date system date or order date? (1997)
SSL and 2.1.1 .acgi (1998)
Resume Catalog ? (1997)
Simple Browser Upload (2002)
multiple search commands (1997)
Heads up, cookies *may* be outlawed in Europe (2001)
Stop the madness. (1997)
[WebDNA] WebDNA Roll Call (2013)
FlushDatabase Suggestion (1998)
Emailer tracking (1997)
Database Field Additions (2000)
[WebDNA] FastCGI version confusion (2011)
America Online Issues (1998)
Emailer port change (1997)