Hi,

I'm building a website, and I want it to be the most dynamically it can be.
I want that the whole pages will be in the DB, and the PHP files will
contain only an SQL query that will fetch the page content from the DB.

Is it common to design the site this way?
Is it harm the performance?
Is there any way to cache the field that contains the page content in order to improve performance?

The General Idea of using MySQL is so you can collect data that you want to change often..or changes for each user..

So you only need to select the information that will be listed in the database...

Although I think waht your saying is you want to contain all the code for the page in the database...right??

Well I think it would be easier to just include all the code into the php files and then just select stuff needed form the database..

-James

I want to place all page content including php code in the DB, so I'll be able to edit the page layout+code through sql queries, without having to upload files.

However, If the price of this implementation is bad performance, I will concede this idea

I dont think it should really affect the load time much...

The SQL Queries usually complete almost instantly..

-James

cuinl,

James is right in that a great number of sites are developed on the internet in this manner and the performance hit of using a database is neglible against latency and propogation times. Most hosts either co-locate their web and database servers together in the same datacenter or even on the same machine.

It's actually a greatly efficient way to develop.