Jump to content

MySQL backed CMS versus file backed - performance differences


bluedoor

Recommended Posts

Hi everyone,

I'm new to the forum because I finally thought of a question for which I really want community input.

Basically:
Will I take a performance hit for using a CMS that stores content in MySQL tables? If so, how big must a site become before this begins to be an issue?

Specifically:
I'm developing a CMS that uses MySQL. As I have it now, each page load does the following with respect to MySQL:
1) Loads server-wide variables from a small table
2) Loads default template variables from a small table
3) Calls page-specific template variables from a small table
4) Loads the content for the page

The template is loaded from a file and PHP goes to work on all the parsing.

Would all this MySQL action ever slow my site down? How efficient is a CMS in general compared to traditional means?

Thanks all
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.