Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How to speed up the database


hobbyfan.com

Recommended Posts

Hi

 

Do anyone have a solution on "how to speed up the database?".

Some of my customer are experencing a slow down when visiting.

The site have a Avg Daily hit in Nov. 916284, Pages 711095, and 1200 unique visitor daily. Are these normal traffic for the database to handle?

 

Please check our site http://hobbyfan.com to see if the slow down affects you. This is a Live Site.

 

Any input would be grateful.

 

thanks

 

Henry

Link to comment
Share on other sites

there is a contribution on how/where to put indices (indexes?) on the database... that might help.

 

Love the site by the way.

 

Mattice

"Politics is the art of preventing people from taking part in affairs which properly concern them"

Link to comment
Share on other sites

I've got an sql database thats 15 MB with 250 tables that handles several times the traffic you stated. Thats no problem for MySQL.

 

You might want to check your hoster's settings for PHP and MySQL, especially the RAM allowed.

 

Regards,

Pierre.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...