Would MySQL be efficient for that project ?

[LikuiD]

Hi,

 

I'm currently making my first major PHP script for a small site containing articles, reviews and stuff like that

Honestly, I've never used a MySQL db before except for storing some small stuff

 

The site would need to store and retrieve the articles' information (title of the article, the whole article(could extend to several hundred words), the author, date of article creation and its rating)

 

So what would be a better option for me in terms of efficiency, as I really wouldn't want to clog the server, a MySQL db or a seperate Php file for each article containing the above variables ?

 

Thanks

[btherl]

A big part of document retrieval is indexing.  And a key advantage MySQL has over files is that it has built in indexing capabilities, even for full text searching.  For that reason alone, I would choose MySQL, even if you can squeeze a bit more speed out of using plain files (and there's no guarantees that you can).