View by manufacturers_id is so slow, why?

[DigitalShadow]

If you visit my website and for example view by manufacturer, these are the stats

Parse Time: 37.432 - Number of Queries: 62057 - Query Time: 12.9304016413

However, if you use the search box and search for that manufacturer, you get this

Parse Time: 3.168 - Number of Queries: 1003 - Query Time: 1.95451326323

Same number of products shown on results page.

Is there anyway to speed up the listing by manufacturer?

[DigitalShadow]

One of the team who make zen cart must be able to answer this one.

[Ajeh]

No clue ... have you an URL to your site that we could perhaps peek at?

[DigitalShadow]

Yep, here you go remove the spaces...

f t v p .co.uk/index.php?main_page=index&manufacturers_id=2

and then searching for the same thing

f t v p .co.uk/index.php?main_page=advanced_search_result&search_in_description=1&keyword=samsu ng

[Ajeh]

Just as a test, turn off the New Products on the Index Listing ...

[Ajeh]

One reason for the slowness is the Category Dropdown of the 1000 Categories that have to be found among the 1000s of Categories that you have ...

Make sure to check also that your indexes on the database tables are complete ...

You could either check the:
/zc_install/sql/mysql_zencart.sql

Or you could install a test directory with a test database so you can see the tables in a database with all of the indexes that should exist ...

You can also look at the SQL statements in the:
/includes/index_filters/default_filter.php

to see what all is in the WHERE statements to see how they are written and the affect your tables would have, especially if missing indexes on your database tables ...

[Ajeh]

Could you go to phpMyAdmin and check some things about this
products_id 10901
Product: Samsung PS-50C450B1W - PSU - BN44-00414A Rev 1.1 - J40 - HU10251-10010
TV Model Number: PS-50C450B1W

Look in the table:
products

and search for the products_id 10901

What is the master_categories_id on this product?


Search for the master_categories_id as the categories_id on the products_id 10901 in the tables:
categories
categories_description

Do you find it? what is the parent_id in the table categories for this categories_id that matches the master_categories_id


Look in the table:
products_to_categories

and search for the products_id 10901

What categories_id come up for this products_id?



Save those categories_id to NotePad ...

Look in the table:
categories
categories_description

and search for those categories_id and see what their parent_id values are ...


Browse your table:
products

how many of the master_categories_id are 0 ... you can do a search for master_categories_id is 0 to get a count ...


Browser your table:
products_to_categories

search on the categories_id for 0 ... how many come up?


What version of Zen Cart are you running?

Clean install or an Upgrade?

Do you use Linked Products?

Are you Importing your Products?

[DigitalShadow]

Turning off new product listing makes no change to speed.

What is the master_categories_id on this product? = 5194

categories = parent_id = 3059

products_to_categories = categories_id = 5194

master_categories_id are 0 = 4 items

products_to_categories -> categories_id 0 = 0 items

v1.3.9h
Clean Install
No linked products
Not importing products

[Ajeh]

Find the 4 products_id that have the 0 on the master_categories_id and set them to their proper master_categories_id ... you can do this by going to the Catalog ... Products ... and find the Products then hit the C for copy and the Multiple Links Manager and set a master_categories_id for them ...

For giggles, switch to the Classic Template and see what the speed is on the Manufacturer look up ...

I am trying to see why your centerboxes are not using the cPath in their URLs ...

[DigitalShadow]

I removed the cPath from the links.

I did this to tidy up the url for social network integration.