CPU load is more than 90% with 3000 sub-categories

[lioncity]

Hi all,

I am using Zen Cart 1.3.8a. There are about 3000 sub-categories in my site.

When clicking on a product, the site speed is very very slow. At the same time, the CPU load used by Apache server is sometimes more than 90%.

How to optimize this situation? which file shall be modified to optimize the site?

Appreciate much if you can give some hints, thank you.

Best regards,
lioncity

[yellow1912]

Turn on the site log in zencart admin for a bit, and post your parsing time and query time etc here. We have to know where it slows down first (usually this will be the database)

There is a module called sql cache by data-digger which can help you.

[lioncity]

Hello,

Thank you very much. The following is the contents of \cache\page_parse_time.log:

****************************************
29/01/2009 09:22:09 [0.322s] /roger/admin/configuration.php?gID=10&cID=248
29/01/2009 09:23:10 - /roger/Wholesale-toner_c5260 (54.268s)
29/01/2009 09:24:08 - /roger/Wholesale-hl1040_c5353 (46.237s)
29/01/2009 09:27:23 - /roger/compatible-brother-tn300-toner_p574.html (7.708s)
29/01/2009 09:28:27 - /roger/ (11.896s)
****************************************



I am using SEO Urls, the following is my .htaccess:
****************************************
Options +FollowSymLinks

RewriteEngine On

RewriteBase /roger/



# From Ultimate SEO URLs

RewriteRule ^print_page_p(.*)$ index\.php?main_page=print_page&products_id=$1&%{QUERY_STRING} [L]

RewriteRule ^(.*)_p(.*).html$ index\.php?main_page=product_info&products_id=$2&%{QUERY_STRING} [L]

RewriteRule ^(.*)_c([0-9]+)$ index\.php?main_page=index&cPath=$2&%{QUERY_STRING} [L]

RewriteRule ^(.*)_c([0-9]+)/([-\w]*)$ index\.php?main_page=index&cPath=$2&display=$3&%{QUERY_STRING} [L]

RewriteRule ^(.*)_c([0-9]+)/([-\w]*)/([-\w]*).html$ index\.php?main_page=index&cPath=$2&display=$3&%{QUERY_STRING} [L]

RewriteRule ^(.*)-m-([0-9]+).html$ index\.php?main_page=index&manufacturers_id=$2&%{QUERY_STRING} [L]

RewriteRule ^(.*)-pi-([0-9]+).html$ index\.php?main_page=popup_image&pID=$2&%{QUERY_STRING} [L]

RewriteRule ^(.*)-pr-([0-9]+).html$ index\.php?main_page=product_reviews&products_id=$2&%{QUERY_STRING} [L]

RewriteRule ^(.*)-pri-([0-9]+).html$ index\.php?main_page=product_reviews_info&products_id=$2&%{QUERY_STRING} [L]



RewriteRule ^producttags/([-\w]+)/$ index\.php?main_page=producttags&letter=$1&%{QUERY_STRING} [L]

RewriteRule ^producttags/([\w])/([0-9]+).html$ index\.php?main_page=producttags&letter=$1&page=$2&%{QUERY_STRING} [L]

RewriteRule ^wishlist/$ index\.php?main_page=wishlist [L]

RewriteRule ^wishlist/([\w])/$ index\.php?main_page=wishlist&letter=$1&%{QUERY_STRING} [L]

RewriteRule ^wishlist/([\w])/([0-9]+).html$ index\.php?main_page=wishlist&letter=$1&page=$2&%{QUERY_STRING} [L]

# For Open Operations Info Manager

RewriteRule ^(.*)-i-([0-9]+).html$ index\.php?main_page=info_manager&pages_id=$2&%{QUERY_STRING} [L]



# For dreamscape's News & Articles Manager

RewriteRule ^news/?$ index\.php?main_page=news&%{QUERY_STRING} [L]

RewriteRule ^news/rss.xml$ index\.php?main_page=news_rss&%{QUERY_STRING} [L]

RewriteRule ^news/archive/?$ index\.php?main_page=news_archive&%{QUERY_STRING} [L]

RewriteRule ^news/([0-9]{4})-([0-9]{2})-([0-9]{2}).html$ index\.php?main_page=news&date=$1-$2-$3&%{QUERY_STRING} [L]

RewriteRule ^news/archive/([0-9]{4})-([0-9]{2}).html$ index\.php?main_page=news_archive&date=$1-$2&%{QUERY_STRING} [L]

RewriteRule ^news/(.*)-a-([0-9]+)-comments.html$ index\.php?main_page=news_comments&article_id=$2&%{QUERY_STRING} [L]

RewriteRule ^news/(.*)-a-([0-9]+).html$ index\.php?main_page=news_article&article_id=$2&%{QUERY_STRING} [L]



# All other pages

# Don't rewrite real files or directories

RewriteCond %{REQUEST_FILENAME} !-f [NC]

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule ^(.*).html$ index\.php?main_page=$1&%{QUERY_STRING} [L]
****************************************

Please kindly advise if you need more information, thank you!

Best regards,

[yellow1912]

Ultimate SEO should not have much effect on the load speed. If you can please post the number of queries executed on this page for example
Wholesale-toner_c5260

can we have a link to your site as well?

[lioncity]

Hi,

Thanks. Sorry I am not clear how to check the "number of queries executed on this page, for example Wholesale-toner_c5260"?

Your advice is greatly appreciated, thank you.

Best,
lioncity

[lioncity]

Hi yellow1912,

Thank you so much!

I will try this http://www.zen-cart.com/forum/showth...ht=query+cache.

My local time is 2am now, I have to go to sleep ;-|, and will keep you update of the result after installing it, thank you again!

Best regards,
lioncity