Messages

Thank you for your answer.

I've written a PL/SQL script wich performs exactly the same you wrote. It contains almost all checks for values included in tables, not dummy "delete from <table>" without any where condition. And it took 14 seconds to execute.

You are right, this is very uncommon operation in production, but now we're in development mode and do this often (in order to clear dirty products or debug data). So we have to suffer this or call native SQL script.

!Btw, deleting category with its products with KonaKart doesn't delete values from products_to_products table! It seems to be a clear bug.

Hi all,

We're using Konakart with large number of products and categories.

There are 562 categories and 10211 of products in database. When we delete categories, this process goes _too slow_, about 5 minutes on good machine. My questions are why and how to speed up this?

(Seems to be trouble is not in konakart but somewhere in Torque ORB?)