Re: AutoCommit Preference?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16464
interpreted = N
texte = >>What triggers this auto-commit activity that makes it slower when it's On than when it's Off?>>If any databases are dirty after the page is returned, they are written to disk. That takes some time, but is of course safer if you have an unstable server.>>>Is it triggered every time a page is requested?>>Yes, but if no databases are dirty, then there is no slowdown.All I was trying to figure out is whether or not having the AutoCommit set to T is going to make WebCat slower than if I continued to use [closedatabase] tags after all my replace and delete commands, like I've been doing all along.From what you're telling me, it seems like using AutoCommit would be even faster than using [closedatabase] tags -- because the [closedatabase] tag actually purges the data from RAM in addition to writing the data to disk, which means using the [closedatabase] tag will always require reloading of the data from disk the next time the db is called.So *assuming* that the AutoCommit checking does NOT slow down the server when the db's are clean, using the new AutoCommit feature would actually be FASTER than using [closedatabase] tags, right?Ah, but how would this compare with using [commitdatabase] tags instead of [closedatabase] tags?Will setting AutoCommit to T be faster than setting it to F and using [commitdatabase] tags after replace and delete commands?Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>>What
triggers this auto-commit activity that makes it slower when it's On than when it's Off?>>If any databases are dirty after the page is returned, they are written to disk. That takes some time, but is of course safer if you have an unstable server.>>>Is it triggered every time a page is requested?>>Yes, but if no databases are dirty, then there is no slowdown.All I was trying to figure out is whether or not having the AutoCommit set to T is going to make WebCat slower than if I continued to use
[closedatabase] tags after all my replace and delete commands, like I've been doing all along.From what you're telling me, it seems like using AutoCommit would be even faster than using
[closedatabase] tags -- because the
[closedatabase] tag actually purges the data from RAM in addition to writing the data to disk, which means using the
[closedatabase] tag will always require reloading of the data from disk the next time the db is called.So *assuming* that the AutoCommit checking does NOT slow down the server when the db's are clean, using the new AutoCommit feature would actually be FASTER than using
[closedatabase] tags, right?Ah, but how would this compare with using
[commitdatabase] tags instead of
[closedatabase] tags?Will setting AutoCommit to T be faster than setting it to F and using
[commitdatabase] tags after replace and delete commands?Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Kenneth Grome
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:
Date subtraction (2002)
XMLNodes Error (2008)
New Problem (1997)
adding up in a db (1997)
form ENCTYPE confusion (2003)
Using the W* upload p-i with webcat (1998)
WebCat & WebTen (1997)
Picking a random entry from a .db (2001)
Where is f2? (1997)
Running _every_ page through WebCat ? (1997)
Pulling Captions from JPGs (2003)
Emailer help....! (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Multi-processor Mac info ... (1997)
[TaxableTotal] - not working with AOL and IE (1997)
[WebDNA] List Files question (2009)
Setting up WebCatalog with Retail Pro data (1996)
Security Tip (1996)
Security hole in WebCat? (1999)
createfolder not behaving as expected (1999)