Re: Databases going to sleep

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 19453
interpreted = N
texte = I agree with what you say. What I meant was you don't want to be flushing the database to disk frequently with a [commitdatabase] when you have a rapidly growing log file. I sometimes to replaces, etc. on log files depending on what the user does. Flushing the changes to disk can be a huge mistake when the log file grows large and volume of visitors increases.Sorry my sleep deprived brain didn't explain better earlier!Sandy>>I do similar logging and have seen blank entries. I prevented it by>>swapping the log file (rolling) whenever the largest reached several>>Megs. Make sure you aren't writing the files to disk with every append>>(an option in preferences or with commitdatabases).>>Sorry Sandy, but this is *not* an option when you use [append] ...>>[append] writes to disk every single time you use it. Only [replace] and >[delete] are affected by setting the preferences differently or by using >[commitdatabase] or [closedatabase] or [flushdatabases].>>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:

Re: Databases going to sleep (Sandra L. Pitner 1998)
Re: Databases going to sleep (Kenneth Grome 1998)
Re: Databases going to sleep (PCS Technical Support 1998)
Re: Databases going to sleep (Sandra L. Pitner 1998)
Databases going to sleep (Thomas Wedderburn-Bisshop 1998)

I agree with what you say. What I meant was you don't want to be flushing the database to disk frequently with a [commitdatabase] when you have a rapidly growing log file. I sometimes to replaces, etc. on log files depending on what the user does. Flushing the changes to disk can be a huge mistake when the log file grows large and volume of visitors increases.Sorry my sleep deprived brain didn't explain better earlier!Sandy>>I do similar logging and have seen blank entries. I prevented it by>>swapping the log file (rolling) whenever the largest reached several>>Megs. Make sure you aren't writing the files to disk with every append>>(an option in preferences or with commitdatabases).>>Sorry Sandy, but this is *not* an option when you use [append] ...>>[append] writes to disk every single time you use it. Only [replace] and >[delete] are affected by setting the preferences differently or by using >[commitdatabase] or [closedatabase] or [flushdatabases].>>Sincerely,>Ken Grome>808-737-6499>WebDNA Solutions>mailto:ken@webdna.net>http://www.webdna.net>>> Sandra L. Pitner

DOWNLOAD WEBDNA NOW!

Re: Databases going to sleep

1998

Top Articles:

Related Readings: