Stephan Miller

21 Sep, 2006

Why use a cache on a database driven site?

Posted by: Stephan Miller In: Php| Programming| Uncategorized| Website Design

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

Because you can get a message like this from your hosting provider when a site starts getting real traffic.

Currently your site is using too many resources on our server (MySQL queries are taking up 20%+ of CPU usage on the server). Please look into the cause of this, particularly recent code changes and updates.

Thanks!

P.S. Please be aware that if your site continues to overuse server resources we may be forced to suspend your account.

A cache will stop these needless database calls. If only a page or two changes on your site daily, don’t make database calls every time. A cache will save the Html of the generated page for however long you specify instead of relaoding the php code.

I found a lot of useful info at the link below. Read up before you get a message like this one.
PHP Tutorials

Share/Save/Bookmark

Tags: , ,

2 Responses to "Why use a cache on a database driven site?"

1 | bitacle.org

September 21st, 2006 at 4:20 am

Avatar

Bitacle Blog Search Archive - Why use a cache on a database driven site?…

[...] Because you can get a message like this from your hosting provider when a site starts getting real. [...]…

2 | rowery (1 comments.)

January 5th, 2008 at 6:47 pm

Avatar

“Why use a cache on a database driven site?” - Good work. Congrats.

rowery’s last blog post..Giant 2007 MTB

Comment Form

WTFMO



Flickr PhotoStream

  • Shozu Desktop
  • IMAGE_012
  • IMAGE_006
  • Highlight Midwest

About

This is my blog about building sites, traffic and using those to make money from ecommerce sites, affiliate programs and blogging.

Subscribe By Email



The One and Only Blogging Magazine

Popular Posts