whats best data storage method - log text file vs database?

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
bertsmilsky
Forum Newbie
Posts: 13
Joined: Fri Jul 18, 2008 10:23 am

whats best data storage method - log text file vs database?

Post 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
User avatar
jayshields
DevNet Resident
Posts: 1912
Joined: Mon Aug 22, 2005 12:11 pm
Location: Leeds/Manchester, England

Re: whats best data storage method - log text file vs database?

Post 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. :)
bertsmilsky
Forum Newbie
Posts: 13
Joined: Fri Jul 18, 2008 10:23 am

Re: whats best data storage method - log text file vs database?

Post by bertsmilsky »

was meaning creating html, not logging errors

yes will look for info before posting!
Post Reply