Admin category display slow loading

[DigiBooks]

Hi

We have LOT of categories in our database and the Admin page load times are quite often very slow. We have done the obvious things like switching off product counting and talking to our host to check that MySQL servers are running OK.

Are there any ways we can increase the page load speeds when we need to select a category to add a product too?

I assume each category line is built in a function before being displayed but (for instance) we don't need the Model column being picked up and displayed nor the Price/Special/Sale or quantity columns as we never use these.

Thanks in advance

[simon1066]

Yes, I remember having this issue with around 250 categories, from memory and comparing my admin files I think you can do two things

1. Disable the 'Go To' dropdown box, in includes/modules/category_product_listing.php

line47 change

 if ($_SESSION['display_categories_dropdown'] == 0) {

to

if (false && $_SESSION['display_categories_dropdown'] == 0) {

2. Disable the check for linked status, the yellow link box will not show,

line 167 change

 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);

to

if (false && 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);

You should see a marked improvement.

I think it was Ajeh who helped out here.

[Design75]

you can start by looking in this file : "YOUR_ADMIN\includes\modules\category_product_listing.php"

This is where the listings in the admin are build

[DigiBooks]

Yes, I remember having this issue with around 250 categories, from memory and comparing my admin files I think you can do two things

1. Disable the 'Go To' dropdown box, in includes/modules/category_product_listing.php

line47 change

 if ($_SESSION['display_categories_dropdown'] == 0) {

to

if (false && $_SESSION['display_categories_dropdown'] == 0) {

2. Disable the check for linked status, the yellow link box will not show,

line 167 change

 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);

to

if (false && 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);

You should see a marked improvement.

I think it was Ajeh who helped out here.

Thank you . I will take a look at that later today

[DigiBooks]

you can start by looking in this file : "YOUR_ADMIN\includes\modules\category_product_listing.php"

This is where the listings in the admin are build

Thanks - I will take a look at that

[DigiBooks]

Yes, I remember having this issue with around 250 categories, from memory and comparing my admin files I think you can do two things

1. Disable the 'Go To' dropdown box, in includes/modules/category_product_listing.php

line47 change

 if ($_SESSION['display_categories_dropdown'] == 0) {

to

if (false && $_SESSION['display_categories_dropdown'] == 0) {

2. Disable the check for linked status, the yellow link box will not show,

line 167 change

 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);

to

if (false && 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);

You should see a marked improvement.

I think it was Ajeh who helped out here.

Hi Simon1066

Well I did those changes and there was a slight improvement in performance (probably something to do with the fact that we currently have a total of 2,343 categories/sub-categories!!!!!!)

So i tracked down a bit further and I have completely commented out the code section:

// bof: categories meta tags
if (zen_get_category_metatags_keywords($categories->fields['categories_id'], (int)$_SESSION['languages_id']) or zen_get_category_metatags_description($categories->fields['categories_id'], (int)$_SESSION['languages_id'])) {
echo '<a href="' . zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories->fields['categories_id'] . '&action=edit_category_meta_tags') . '">' . zen_image(DIR_WS_IMAGES . 'icon_edit_metatags_on.gif', ICON_METATAGS_ON) . '</a>';
} else {
echo '<a href="' . zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories->fields['categories_id'] . '&action=edit_category_meta_tags') . '">' . zen_image(DIR_WS_IMAGES . 'icon_edit_metatags_off.gif', ICON_METATAGS_OFF) . '</a>';
}
// eof: categories meta tags

as we have no need whatsoever for metatags.

The Admin section is now absolutely FLYING!!!!!

Thank you for putting me onto the right track

[simon1066]

That's good to know about the meta-tags, I might try that too as I don't plan to be editing/adding them any time soon.

[DigiBooks]

That's good to know about the meta-tags, I might try that too as I don't plan to be editing/adding them any time soon.

I tried adding back in the GOTO drop down and it really slowed up again but I have to say the metatags were killing the page loads!!

Again not only do we have 2343 categories but just under 8500 products so you can see why metatags are a real problem here.

[mc12345678]

Seeing that there was minimal improvement in the first round of editing, I might suggest at least restoring the 'Go To' dropdown. Just a suggeston because otherwise you are forced to navigate all the categories manually. Maybe not used often, but can be a time saver.

[Ajeh]

NOTE: Next to the Dropdown is either a Checkmark or an X if you click that it enables and disables the Category Drop down ...