The queries are off the hook indeed....

• As suggested turn off category counts in catalog and admin
• Remove one of your Google Analytics scripts... you only need one :dontgetit
• replace your html_header.php with the correct default file as you broke it severely
• Clear the cache for whatever url rewrites you are using. Also try disabling it... Lot of load speed being sucked up here
• Fix your code errors

Also have a look at this, you are slow otherwise as well http://www.showslow.com/details/?url=http%3A%2F%2Fwww.solutioninn.com%2F

~Melanie

Christian, please check i have removed the category count now.

I gave both links because you can realize the query time not the number of queries. The problem is with query time. It takes long query time on dedicated server than shared hosting. Number of queries are same on both.

I want you to please check that problem.

Queries are much better, load is still awful and the parse time is VERY slow.

Your queries

Parse Time: 15.453 - Number of Queries: 334 - Query Time: 13.679399868958

Some examples from our sites

Parse Time: 0.199 - Number of Queries: 116 - Query Time: 0.0553404656525

Parse Time: 0.231 - Number of Queries: 96 - Query Time: 0.0383298583984

You can turn off boxes in Tools >> Layout Boxes Controller that are not being used as well.

Your can disable downloads and text pricing if not in use in Configuration >> Attribute Settings

You can enable compression in Configuration >> GZip Compression

Last in Tools >> Store Manager >> Clear your admin log and optimize your database.... AFTER you back it up.

~Melanie

You can turn off boxes in Tools >> Layout Boxes Controller that are not being used as well.
(This is just for main page), you can check the query time on other pages where there are no side boxes.

Your can disable downloads and text pricing if not in use in Configuration >> Attribute Settings
(This is just download products so i can't disable this option)

You can enable compression in Configuration >> GZip Compression (I have done it)

Last in Tools >> Store Manager >> Clear your admin log and optimize your database.... AFTER you back it up.

(I have done it)

Can you check now?

Please check it on https://www.solutioninn.com (shared hosting)

A smidge faster... 66/100

• Remove one of your Google Analytics scripts... you only need one
• replace your html_header.php with the correct default file as you broke it severely
• Clear the cache for whatever url rewrites you are using. Also try disabling it... Lot of load speed being sucked up here
• Fix your code errors

Also have a look at this, you are slow otherwise as well http://www.showslow.com/details/?url=http%3A%2F%2Fwww.solutioninn.com%2F

No escaping the fact that you need a new webhost either.

~Melanie

Dear, can you please help me with

https://www.essaysbundle.com which is on dedicated hosting. Still the time is for main page Parse Time: 33.122 - Number of Queries: 333 - Query Time: 31.638034605011

where as it is quite less in shared hosting.

Look both of them are same websites nothing changed. Then why it is taking long time in dedicated as compare to shared? Rather shared should be much slower.

The dedicated is much faster that the shared, but still DOGGGGG slow. You need a new webhost.

~Melanie

Parse Time: 19.085 - Number of Queries: 344 - Query Time: 17.45815809552

There is a really bad bottleneck somewhere or server misconfiguration.

We have a customer running with 150,000 products and his parse time is this:
Parse Time: 1.836 - Number of Queries: 668 - Query Time: 1.08748966496

Hi,

On the dedicated server try installing a default Zen Cart database with the test products. We can then see if it is the database causing the problem or the server configuration.

Regards,
Christian.

wow that is slow. We have one on shared hosting that get the following:

Parse Time: 0.644 - Number of Queries: 4080 - Query Time: 0.404899159012

and another on a dedicated box getting:

Parse Time: 1.488 - Number of Queries: 10381 - Query Time: 0.9076799953

It doesn't look like your products are priced by attributes, i.e. their price is their price. If that's true, you want to make sure that all your products' "Product is Priced by Attributes" radio box (seen/modified via admin Catalog->Categories/Products or Products Price Manager) is set to "No". That will negate the attributes' query for every product price/weight calculation, and reduce your database hits substantially.

'Lat9' Sorry, can you please elaborate your question related with price attributes?

I have tried the new installed copy on dedicated server along with my 70 MB .sql file. It is working perfectly alright giving time parse less than 0.5 seconds. But as soon as i copy my zen cart files it gets very slow and reaches to 30 seconds.

Do you think these files are causing it slow?

One more thing, as soon as i copy 'includes' folder into my new installation files on dedicated server. The entire websites gets very slow.

What do you say now?

fawad123:

One more thing, as soon as i copy 'includes' folder into my new installation files on dedicated server. The entire websites gets very slow.

What do you say now?

I would say that there is a problem with your Zen Cart files. Use something like Winmerge to compare them to a clean set of files and see what add-ons or changes have been made. You'll need to review each carefully to see if it is causing the problem.

Alternatively start with a fresh installation of ZC 1.3.9d get that working then install each add-on you require and test after installing each one.

Regards,
Christian.

solutioninn.com Tested today

testing with no cache (firebug in Firefox)
Parse Time: 16.897 - Number of Queries: 322 - Query Time: 16.253198375534

testing with no cache AND disable all images
Parse Time: 0.586 - Number of Queries: 323 - Query Time: 0.31138602593994

I'm sorry to say that your current zen-cart with your modifications has errors.
Validate HTML solutioninn.com
If you repair the errors, your site will be faster. See the hints from mprough and myself.

Or you start with a new zen-cart 1.39d installation.

Check the image in your review menthol. It is missing OR the permissions in the directory /images/ are incorrect. simple solution is to remove that review or turn off the review sidebox

This is a start.

Your server reports sometimes errors (404 not found) on javascript_check.php and that causes a delay of 6 sec.

After that you can check the speed again.

Good luck

fawad123:

'Lat9' Sorry, can you please elaborate your question related with price attributes?

I have tried the new installed copy on dedicated server along with my 70 MB .sql file. It is working perfectly alright giving time parse less than 0.5 seconds. But as soon as i copy my zen cart files it gets very slow and reaches to 30 seconds.

Do you think these files are causing it slow?

One more thing, as soon as i copy 'includes' folder into my new installation files on dedicated server. The entire websites gets very slow.

What do you say now?

To see if your products are priced by attributes, go to your admin's Catalog->Product Price Manager and choose a product. There is a line of 6 radio buttons near the bottom of the display; the right-most is "product is priced by attributes". If the "yes' button is checked, the product is priced by attributes.

When you say "as soon as i copy my zen cart files", which "files" do you mean (especially since you indicate that you copy your includes folder as a separate action)?

Rik, thank you so much for these detailed analysis i'll definitely going to modify the changes you have pointed out.
But you know i was more concerned about same website on dedicated server (http://www.essaysbundle.com) which is taking so long to open a single page.

After 3 weeks of effort and discussion with users like you i have found the problem but still looking for good solution.
After migration from shared to dedicated server the main problem was the speed that i used to get more than 30 seconds to open one page on dedicated server but today i have reached to the exact problem.

THe problem is SEO Ceon URI Mapping if i disable it then i'm getting this time on my dedicated server

Parse Time: 0.297 - Number of Queries: 219 - Query Time: 0.07835233895874

Which i think is much better.

Now the server goes down as soon as i turn on SEO Ceon URI mapping.

I can't turn it off because all my webpages are indexed with this Ceon URI mapping with Google.

Please suggest me the solution

Here is the .htaccess file used at shared hosting but when it is used on dedicated it gives low performance:

RewriteEngine On

Don't rewrite any URIs ending with a file extension (ending with .[xxxx])

RewriteCond %{REQUEST_URI} !.[a-zA-Z]{2,4}$

Don't rewrite admin directory

RewriteCond %{REQUEST_URI} !^/admin.* [NC]

Don't rewrite editors directory

RewriteCond %{REQUEST_URI} !^/editors.* [NC]

Don't rewrite cPanel directories

RewriteCond %{REQUEST_URI} !/cpanel.* [NC]
RewriteCond %{REQUEST_URI} !/frontend.* [NC]

Handle all other URIs using Zen Cart (index.php)

RewriteRule (.*) index.php?%{QUERY_STRING} [L]

#RewriteCond %{HTTP_HOST} ^essaysbundle.com$ [NC]
#RewriteRule ^(.*)$ http://www.essaysbundle.com/$1 [R=301,L]

fawad123:

THe problem is SEO Ceon URI Mapping if i disable it then i'm getting this time on my dedicated server

Parse Time: 0.297 - Number of Queries: 219 - Query Time: 0.07835233895874

Which i think is much better.

Now the server goes down as soon as i turn on SEO Ceon URI mapping.

I can't turn it off because all my webpages are indexed with this Ceon URI mapping with Google.

Please suggest me the solution
In Admin, select Tools then 'Install SQL Patches', copy and paste the following into the text box and hit 'Send'...

ALTER TABLE `ceon_uri_mappings` ADD INDEX ( `language_id` , `current_uri` , `main_page` , `associated_db_id` ) ;
```The CEON URI mapping add-on is very bad at doing database lookups and I wouldn't  recommend it for anything other than a tiny store. The above should speed things up for you though.

Regards,
Christian.

Thanks christian, i have tried it but it has now decreased to

Parse Time: 19.300 - Number of Queries: 306 - Query Time: 19.086902418549

Is there any more optimization or do you have any alternative solution for that?

fawad123:

Thanks christian, i have tried it but it has now decreased to

Parse Time: 19.300 - Number of Queries: 306 - Query Time: 19.086902418549
I've just tried it and it now seems to be running a lot faster than 19 seconds. The homepage gives me...
Parse Time: 1.356 - Number of Queries: 387 - Query Time: 0.239814745224

fawad123:

Is there any more optimization or do you have any alternative solution for that?
There is more that can be done but we have to identify where the bottle necks are. What version of CEON URI mapper are you using?

Regards,
Christian.