admin/categories.php running super slow...

[ksoup]

I came up with the following queries to check what you said to start checking ... i hope the logic is right....


all master_categories_id in the products table are in the categories table ... returns 0 results (great if the query is right)

SELECT
`zen_products`.`master_categories_id`
FROM
`zen_products`
Inner Join `zen_categories` ON `zen_categories`.`categories_id` = `zen_products`.`master_categories_id`
where `zen_categories`.`categories_id` is null

all categories_id in the products_to_categories table are in the categories table ...returns 0 results (great if the query is right)

SELECT
`zen_categories`.`categories_id`,
`zen_products_to_categories`.`products_id`
FROM
`zen_categories`
Inner Join `zen_products_to_categories` ON `zen_products_to_categories`.`categories_id` = `zen_categories`.`categories_id`
where `zen_products_to_categories`.`products_id`
 is null

all products_id in the products table are in the products_to_categories table ... returns 61 results (spot checking the first two reveals that those products have a blank entry on the products table - i need to go through and handcheck the rest of the 61 returned)

SELECT
`zen_products_to_categories`.`products_id` as zptc_prodid,
`zen_products`.`products_id` as zp_prodid,
`zen_products_to_categories`.`categories_id` as zptc_catid
FROM
`zen_products_to_categories`
right Join `zen_products` ON `zen_products_to_categories`.`products_id` = `zen_products`.`products_id`
where `zen_products_to_categories`.`categories_id`is null

who knew cleaning could be so fun. :)

[Ajeh]

These might help too:
MATCH MISSING PRODUCTS_TO_CATEGORIES

SELECT * FROM products WHERE products.products_id NOT IN (SELECT products_to_categories.products_id FROM products_to_categories);

SELECT * FROM products_to_categories WHERE products_to_categories.products_id NOT IN (SELECT products.products_id FROM products);

MATCH MISSING ON master_categories_id

SELECT * FROM products WHERE products.master_categories_id NOT IN (SELECT products_to_categories.categories_id FROM products_to_categories);

SELECT * FROM products WHERE products.master_categories_id NOT IN (SELECT categories.categories_id FROM categories);

NOTE: these need to be edited for prefixes ...

[Ajeh]

ksoup ... how much did the changes speed up your Categories/Products?

Does it need more tweaking?

[ksoup]

I was just testing as you wrote... it is rockin' through now! Thank you!

ksoup ... how much did the changes speed up your Categories/Products?

Does it need more tweaking?