2 replies to this topic

[neo1erk]

I want to make a website manager, however i am wondering how efficient it is to store files in a database. While i am trying to hardcode text where possible, should i be going out of my way to hardcode pages, or does it not matter that much, when compared to the ease of storing them in a database.
So my question is: are there any disadvantages from storing a lot of stuff in the database? i know forum sites store all their content there, so i don't think it would a problem.
Any thoughts would be appreciated.
Thanks

[WingedPanther]

The biggest disadvantage I can see is trying to alter the pages. On the other hand, if you have a huge site where you want to index the pages by search parameters, you can store the page with the parameters as additional fields in the record.

Are you doing any server-side scripting? That may help reduce the number of pages you need to deal with.

[neo1erk]

I am doing the project in php. I think will store them in the database, since i want to be able to make mods and addons, and having a database would make it easier to get the data into php.

Thanks for your thoughts. Only thing i am trying to find is ways to cache common database queries in mysql. I was hoping just to be able to put menu's into the database just for ease of editing.