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 Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://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 Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://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:
[OT] CSS and SSI books (2004)
Tiger / WebDNA (2005)
RE: Fishing: anyone on this group willing to do support? (1998)
[WebDNA] NOT serving WebDNA, just running it locally. (2012)
emailer on Windows Beta 18 (1997)
Bug Report, maybe (1997)
redirect with frames (1997)
Shell script within a sandbox (2005)
list archives (2004)
Append..... doesn't (2000)
trouble updating records in database (1998)
Colocator Upgrading OS (2004)
Bug Report, maybe (1997)
For Grant: Webcatalog 4.0 - When will we be able to betatest it? (2000)
Re:Copyright ? (1997)
PCS Frames-Default page is solution! (1997)
Please.. copies of Digest for 7/29 and 7/30? (1997)
BIG PROBLEMS with Checkboxes!!! (1998)
Listserver problem (1997)
calculating tax rates, mail order solutions and version 2 (1997)