Quote Originally Posted by mikeel100 View Post
I just changed the configure.php files cache method to "database" and was able to access admin/catalog/categories/products...3 times in a row. However, it still takes over 2 minutes to show the categories/folders. I have 1841 categories/subcategories.
1. The admin display of categories/products doesn't utilize any cached queries beyond what MySQL caches on its own.

2. The code which handles categories/products in the admin, or even non-admin for that matter, had no significant changes between v154-v155 ... basically the only change was when displaying a product to dynamically look up image subdirectory names using a shared function instead of duplicating the code across every product-type ... and even that should have no bearing on your situation.

3. Common causes of the admin category/product listing to be slow include:
- broken master_categories_id values set on product records (ie: out of sync; see previous discussion above)
- dropped indexes on MySQL tables ... which usually only happens when doing imports where the export didn't include indexes, which is rare, but shouldn't be overlooked. The default indexes supplied on all the tables should suffice provided one hasn't altered the ZC core code via plugins or customizations
- damaged tables -- you already said you ran a repair

4. You haven't listed all the ways in which your site's code differs from original ZC v1.5.5a distribution code. What customizations or plugins have altered things?