Page 1 of 1
whats best data storage method - log text file vs database?
Posted: Tue Jan 20, 2009 12:47 pm
by bertsmilsky
I am building a cms system and want to know the pros and cons of different ways of storing data. Is there any logical rule that might make you choose one method over another - for example logging text files over using a database?
Any advice would be much appreciated!
Thanks
Re: whats best data storage method - log text file vs database?
Posted: Tue Jan 20, 2009 1:05 pm
by jayshields
There's alot on the net about this already.
If you mean which is best for simply storing and retrieving data it's different to if you're going to be using it for event logging or not (I don't know which you mean because of how you worded it). Mainly because you would never read from a log file in your application, but perform lots of writes. Also, if you're using database logging for catching errors and there's an error in connecting to the database then you're not going to see it.
Look around on Google for a bit before posting further questions.

Re: whats best data storage method - log text file vs database?
Posted: Tue Jan 20, 2009 1:16 pm
by bertsmilsky
was meaning creating html, not logging errors
yes will look for info before posting!