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
whats best data storage method - log text file vs database?
Moderator: General Moderators
-
bertsmilsky
- Forum Newbie
- Posts: 13
- Joined: Fri Jul 18, 2008 10:23 am
- 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?
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.
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?
was meaning creating html, not logging errors
yes will look for info before posting!
yes will look for info before posting!