One main issue on this is the server and how it is configured for php and MySQL in regard to memory and cache ... and in plain performance ...
What runs at .5 seconds on one server can run at 45 seconds on another ...
That said, let's explore how to speed up your page ...
Try to go to the Categories/Products, then wait for the time out ...
Peek in your temp directory for your browser ( sort by date to find it fastest, it's the monster file you see in there ) and you can see how huge this page is as a temp file from the browser ... this is why you time out ... it has to download for you to see it ...
For giggles and grins turn on your Parse times ... they will eventually be able to display ...
These are things that speed up the Categories/Products when you have a built like your's ...
Try them one at a time to see which effects you the most ...
Turn off the Categories Count in the Admin:
Configuration ... My Store ...
Show Category Counts - Admin
Show Category Counts in Admin?
true
false
Test speed ...
Note: with the next several changes, try this with that setting ON and OFF to see the relative effect of "where" the slow down really is ...
Note: there are no overrides for this so maintain a backup of the original and changed files for the future ...
Edit the file:
/admin/includes/modules/category_product_listing.php
Next, try turning off the Categories Dropdown ... your's is very huge and trying to draw it is 32,000+ rows ...
Change around lines 16-18:
PHP Code:
if (!isset($_SESSION['display_categories_dropdown'])) {
$_SESSION['display_categories_dropdown'] = 0;
}
To read:
PHP Code:
if (!isset($_SESSION['display_categories_dropdown'])) {
$_SESSION['display_categories_dropdown'] = 1;
}
That shuts off the dropdown ... building it is not so much the issue as displaying and downloading it ... a 32,000+ dropdown is a monster ...
Test speed ...
Around lines 165 - 167 change:
PHP Code:
if (zen_get_products_to_categories($categories->fields['categories_id'], true, 'products_active') == 'true') {
echo ' ' . zen_image(DIR_WS_IMAGES . 'icon_yellow_on.gif', IMAGE_ICON_LINKED);
}
PHP Code:
// turned off for speed
if (false) {
if (zen_get_products_to_categories($categories->fields['categories_id'], true, 'products_active') == 'true') {
echo ' ' . zen_image(DIR_WS_IMAGES . 'icon_yellow_on.gif', IMAGE_ICON_LINKED);
}
}
Test speed ...
After testing these, let us know where you are at and we can look at other issues ... have fun!
Bookmarks