Re: Log files

Mark Bomgardner wrote:

I am writing an application in which I want to create log files. I am weighing the difference between using text files and using a database to house the data. It appears to me that there is really no advantage either way or is there? There are pros and cons to both methods, but I am concerned about opening and closing a text file some many times that it may cause and issue. The file may be opened and closed 1,000 or more times a day. Opinions please.. markb

Using a database you're hitting a file the same number of times (the database is in a file or files) but you have the mem/cpu overhead of the db itself. Having said that, if you are using a database already for the site then might as well log to it. I wouldn't implement a database only for the purpose of logging. -Shawn