I am building a web site and I want to add a very simple content manager (which I will build myself).
The two ways I know how to do it are:
1. using MySQL to store all of the pages.
2. without using MySQL, storing all of the data in files using fopen, fwrite,...
Which one is better, and why?
MySQL vs data files
Moderator: General Moderators
- waytoecommerce
- Forum Newbie
- Posts: 16
- Joined: Tue Apr 12, 2011 11:47 am
Re: MySQL vs data files
see if you will use first one it will be better since Mysql is fast and response very quickly then any other process. If you store data in files may in future it will create problem in opening the file.
As the experience on both the things I will recommend you to go for the first one.
As the experience on both the things I will recommend you to go for the first one.
- social_experiment
- DevNet Master
- Posts: 2793
- Joined: Sun Feb 15, 2009 11:08 am
- Location: .za
Re: MySQL vs data files
It depends on whether you can get mySQL (which these days shouldn't be a problem). If you can get a mySQL database there is no reason why you should go with a flat file system. Each one of these have their own pro's / cons though which will make them more suitable for different applications.
http://www.databasedev.co.uk/flatfile-vs-rdbms.html
http://www.databasedev.co.uk/flatfile-vs-rdbms.html
“Don’t worry if it doesn’t work right. If everything did, you’d be out of a job.” - Mosher’s Law of Software Engineering