MySQL or XML to build a site template?

[RastaLulz]

I was wondering what would be a more efficient way to build a template for my CMS.

At the moment, the template is being taken out of the MySQL database every time the site is loaded, and I'm worried that this will cause issues on a live production site with many visitors.

Here's how it looks like at the moment:

You must be registered to see links

With that being said, would it be better performance wise to put the template into an XML file, or a simple txt file and getting the template from there.

:?:

 

[jMerliN]

I was wondering what would be a more efficient way to build a template for my CMS.

At the moment, the template is being taken out of the MySQL database every time the site is loaded, and I'm worried that this will cause issues on a live production site with many visitors.

Here's how it looks like at the moment:

You must be registered to see links

With that being said, would it be better performance wise to put the template into an XML file, or a simple txt file and getting the template from there.

:?:

Why are you storing the template in SQL at all? SQL isn't your filesystem.

It'd be best to save it to a cache folder locally. Look into what Smarty does.

 

[Supicioso]

Why ARE you storing a site in MySQL?

 

[cPanel]

why you doing in MySQL

 

[RastaLulz]

Is it really necessary to repeat the same thing multiple times?

Why are you storing the template in SQL at all? SQL isn't your filesystem.

At the time I was developing this CMS, this was the easiest way to go about it, and it was only on my localhost. Now that I have plans to use it on a bigger site, I am looking into possibly performance issues, and trying to get it as efficient as I can.

It'd be best to save it to a cache folder locally. Look into what Smarty does.

Thanks for the advice - I will be sure to look at Smarty. :8:

Anyways, closing this thread as my question has been answered.