My Admin interface very slow

I have a lot of categories and products in our website - 16k/100k estimated.

The website itself is great. Did a lot of tuning and optimization and response time is generally sub-second. Here's my problem: The Admin interface is painfully slow. Bringining up the cat/prod view or attribute view takes forever simply because it takes so long to load all those categories in the drop-downs.

Is there a way to eliminate this thru mod that uses a search rather than a browse? Any other ideas? 99% of our data maintenance happes programatically but when you need to manually tweak something, it takes forever!

Thanks!

There are a lot of things that can be done to that display to speed it up ...

How many Categories do you have?

Do you use Linked Products?

I have to look up the little switches here and there to speed it up but I have taken sites from 200+ seconds to .5 to 2 seconds by making some customizations on the pages to speed things up ...

I have 16,000 categories and 50,000 products. Nearly every product is linked. PTC is over 100,000 rows.

I removed the categories dropdown box from the categories display. That helped tremendously. If I can remove it from the attributes controller I'll be golden, but I cannot figure that out since it doesn't seem to use the zen_get_cat_tree() ( not exact function name I think) function.

You can customize the module for:
products_previous_next_display.php

However, this is used all over, so be careful of the changes you make ...

The URL does need the:
&current_category_id=XXX

for managing the products to display ... where XXX is the immediate categories_id that you are working on ...

I have 16,000 categories and 50,000 products.
Organize - organize--- that is only 3 products per cat there must be a better organization for your items.

We have 120,000 products and while not extremely fast on the admin side it is useable.

Thank you both for the help. Ajeh I'll take a look at where that's used. It may reduce our functionality to some degree on manual editing, but most products are edited via the search function rather than manual lookups, so I suspect it will be okay.

Kobra, It's not quite that bad as the category heirarchy is quite deep at times so it's really 10-15 products per category on average when you get down to the lowest level which I think is a reasonable amount.

Hi Ajeh

I like the sounds of the tweaks you did - are they written down anywhere?
(27 categories and 2800 products - but latley its deathly slow - and times out to a blank page on store manager and other items, so I would certainly like to track deeper)

thanks
Sarah

I'll post them later this morning.

Here are the areas where I removed the category list:

Catalog:
includes/templates/template_default/templates/tpl_advanced_search

• Delete the fieldset for the category box

Admin:

admin/includes/modules/category_product_listing.php

Comment out line 61, edit to: // echo HEADING_TITLE_GOTO . ' ' . zen_draw_pull_down_menu('cPath', zen_get_category_tree(), $current_category_id, 'onChange="this.form.submit();"');

admin/includes/modules/product_prev_next_display.php

Edit line 33 to (note comment slashes before "echo") - <td align="left" class="main"><?php echo zen_draw_form('new_category', $curr_page, '', 'get'); ?>  <?php //echo zen_draw_pull_down_menu('current_category_id', zen_get_category_tree('', '', '0', '', '', true), '', 'onChange="this.form.submit();"'); ?><?php echo zen_draw_hidden_field('products_filter', $_GET['products_filter']); echo zen_hide_session_id(); echo zen_draw_hidden_field('action', 'new_cat'); ?>  </form></td>