Re: [WebDNA] To Commitdatabase or Not to Commitdatabase
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108408
interpreted = N
texte = > So would a FlushDatabases, which I understand is All DB Written to = Disk be a "slower" task compared to a [commitdatabas....] after every = [replace/append] ? I would assume that flushing all databases to disk would be slower. = About [FLUSHDATABASES] the manual says it, "causes all databases to be = written and closed". Why would you want to *close* the database just = to make sure the data is on disk? Then upon the very next operation = that involves that database, you have to load it all back into RAM = again. I would not close the database (remove it from RAM) unless = there was a reason to do so. I would also not commit to disk, nor = remove from RAM, ALL databases at once, unless there was a reason to do = so. =20 [COMMITDATABASE..] lets you precisely write to disk (but not flush from = RAM) *just the database you specify*. >=20 > And how do you normally avoid data loss? Are you using the = [commitdatabase...] ?? Well my clients are all over the map.. on different hosts, etc. Some = have auto-commit turned on via the admin interface.. Other = times/places I do use [commitdatabase...], specifically, when/where = needed. -G=
Associated Messages, from the most recent to the oldest:
> So would a FlushDatabases, which I understand is All DB Written to = Disk be a "slower" task compared to a [commitdatabas....] after every = [replace/append] ? I would assume that flushing all databases to disk would be slower. = About
[flushdatabases] the manual says it, "causes all databases to be = written and closed". Why would you want to *close* the database just = to make sure the data is on disk? Then upon the very next operation = that involves that database, you have to load it all back into RAM = again. I would not close the database (remove it from RAM) unless = there was a reason to do so. I would also not commit to disk, nor = remove from RAM, ALL databases at once, unless there was a reason to do = so. =20 [COMMITDATABASE..] lets you precisely write to disk (but not flush from = RAM) *just the database you specify*. >=20 > And how do you normally avoid data loss? Are you using the = [commitdatabase...] ?? Well my clients are all over the map.. on different hosts, etc. Some = have auto-commit turned on via the admin interface.. Other = times/places I do use [commitdatabase...], specifically, when/where = needed. -G=
Govinda
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:
Updating checkboxes made easy !!! (1998)
New Installation (1998)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Categories and Sub-categories (2003)
question about checkboxes (1999)
[numfound] within summ=t ??? (2000)
access denied problem (1997)
Searchable WebCat (etc.) Docs ? (1997)
WebCatalog can't find database (1997)
Pass a form (2003)
Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997)
price on detail, but not shoppingcart (1997)
CASTEGORIES IN DIFFERENT FRAMES (1997)
[WebDNA] OS X Server 5.04 Update (2015)
RE: [WebDNA] Crashing (2008)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Showif, Hideif reverse logic ? (1997)
Re[3]: Problem with new formvariables (2000)
Stopping bad HTML propagation ? (1997)
Generating unique SKU from [cart] - Still Stumped... (1997)