Re: 'page impression' techniques for banner ads
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22205
interpreted = N
texte = >WHY can't the databases be automatically saved to disk and the ram freed>when a replace, append, write etc... contexts is (are) sent?They are committed to disk automatically when you set the AutoCommit preference to T -- but that does not 'free your RAM'. Then again, I see no purpose in worrying about freeing RAM anyways, since webcat frees automatically whenever it needs it ...I think these are some practical techniques to consider:1- Set AutoCommit to T if you want *every* db change to be written to disk *every time*. Then you never have to worry about it again ... but you'll have lots of disk hits .. and if you're using WebTen, your server will crash a lot (as demonstrated by more than one user on the WebTen-Talk list).2- Set AutoCommit to F and use the [commitdatabase] tag at the end of a template only when you need to commit a certain db to disk that was changed in that template. This takes more 'thinking' when you're writing your webdna code, but it's the option offering the best 'precision' ...3- If you wish to commit some or all db's on a regular basis instead of every time they are changed, set AutoCommit to F and create a special template with all your [commitdatabase] tags in it, then make the triggers.db call this special template periodically, say once an hour ...Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>WHY can't the databases be automatically saved to disk and the ram freed>when a replace, append, write etc... contexts is (are) sent?They are committed to disk automatically when you set the AutoCommit preference to T -- but that does not 'free your RAM'. Then again, I see no purpose in worrying about freeing RAM anyways, since webcat frees automatically whenever it needs it ...I think these are some practical techniques to consider:1- Set AutoCommit to T if you want *every* db change to be written to disk *every time*. Then you never have to worry about it again ... but you'll have lots of disk hits .. and if you're using WebTen, your server will crash a lot (as demonstrated by more than one user on the WebTen-
Talk List).2- Set AutoCommit to F and use the
[commitdatabase] tag at the end of a template only when you need to commit a certain db to disk that was changed in that template. This takes more 'thinking' when you're writing your webdna code, but it's the option offering the best 'precision' ...3- If you wish to commit some or all db's on a regular basis instead of every time they are changed, set AutoCommit to F and create a special template with all your
[commitdatabase] tags in it, then make the
triggers.db call this special template periodically, say once an hour ...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:
SSL and WebCatalog (1997)
Re:PCS Customer submissions ? (1997)
Re[2]: Malformed Pages (1999)
Slightly [OT] Trying to get clients SQL system going (2005)
Can this be done? (2003)
WCS Newbie question (1997)
Error Lob.db records error message not name (1997)
RE: Is there a 'does not contain' comparison? (1999)
WebTen and WebCat (1997)
Extended [ConvertChars] (1997)
RE: Can't get appendfile to work (1997)
WebCat 5 (2003)
[OT] What log analyzer do you use? (2000)
authorize.net hex coded variables OOPS (2002)
[format] minus figures (2003)
Does anyone have a TCPconnect that does multiple sends... (2000)
Robert Minor duplicate mail (1997)
Multiple Newcarts (1996)
Interfacing WebMerchant to www.fedex.com (1997)
Draft Manual, Tutorial, and more (1997)