I have over 100,000 products in my DB. I cannot edit and save a product. Running a profiler I came to a conclusion that there are a lot of processes running for saving a single product. Eg.
339,948: Mage_Rule_Model_Condition_Product_Abstract -> getAttributeObject via Mage_Eav_Model_Config -> getAttribute <cycle 6> (abstract.php)
339,948: Mage_Rule_Model_Condition_Product_Abstract -> getAttributeObject via Mage::getSingleton <cycle 6> (abstract.php)
42,493 Mage_Catalog_Model_Resource_Product>getCategoryIds via Zend_Db_Adapter_Abstract->fetchCol <cycle 6> (Product.php)
42,493 Mage_Catalog_Model_Resource_Product>getCategoryIds via Mage_Core_Model_Abstract->getId <cycle 6> (Product.php)
42,493 Mage_Catalog_Model_Product>getCategoryIds via Mage_Catalog_Model_Product->_getResource <cycle 6> (Product.php)
Does anyone have any suggestion what I can do? Please HELP!