Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Upgrading no problem but; Slow performance after upgrade and Cache issue
 
Mom2B
Jr. Member
 
Total Posts:  24
Joined:  2009-03-09
 

Hi all,

After upgrading www.babyonboard.nl to 1.3, with only few mod777 issues so no problem at all (!), I noticed that front and backend are very slow. The only problem is that I don’t know if it has to do with provider issues or just the installation. I tried 2 different internet providers, the fastest available in NL, and both take some more time loading pages and making adjustments than in the previous version.

Also while rebuildin Flat Catalog Product I get following error:

exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘’ for key 2’ in /var/www/vhosts/babyonboard.nl/httpdocs/lib/Zend/Db/Statement/Pdo.php:238 Stack trace: #0 /var/www/vhosts/babyonboard.nl/httpdocs/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/vhosts/babyonboard.nl/httpdocs/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array) #2 /var/www/vhosts/babyonboard.nl/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(’UPDATE `catalog...’, Array) #3 /var/www/vhosts/babyonboard.nl/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(259): Zend_Db_Adapter_Pdo_Abstract->query(’UPDATE `catalog...’, Array) #4 /var/www/vhosts/babyonboard.nl/httpdocs/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Flat/Indexer.php(637): Varien_Db_Adapter_Pdo_Mysql->query(’UPDATE `catalog...’) #5 /var/www/vhosts/babyonboard.nl/httpdocs/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Flat/Indexer.php(655): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Flat_Indexer->updateAttribute(Object(Mage_Catalog_Model_Resource_Eav_Attribute), ‘1’, NULL) #6 /var/www/vhosts/babyonboard.nl/httpdocs/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Flat/Indexer.php(118): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Flat_Indexer->updateEavAttributes(’1’) #7 /var/www/vhosts/babyonboard.nl/httpdocs/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Flat/Indexer.php(108): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Flat_Indexer->rebuild(’1’) #8 /var/www/vhosts/babyonboard.nl/httpdocs/app/code/core/Mage/Adminhtml/controllers/System/CacheController.php(235): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Flat_Indexer->rebuild() #9 /var/www/vhosts/babyonboard.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(367): Mage_Adminhtml_System_CacheController->saveAction() #10 /var/www/vhosts/babyonboard.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(247): Mage_Core_Controller_Varien_Action->dispatch(’save’) #11 /var/www/vhosts/babyonboard.nl/httpdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #12 /var/www/vhosts/babyonboard.nl/httpdocs/app/Mage.php(457): Mage_Core_Controller_Varien_Front->dispatch() #13 /var/www/vhosts/babyonboard.nl/httpdocs/index.php(52): Mage::run() #14 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
MarcelP102
Member
 
Total Posts:  55
Joined:  2009-03-09
 

Hi I tested yor site and it loads very quick (I also live in NL)

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mirasvit
Guru
 
Avatar
Total Posts:  639
Joined:  2009-08-22
 

Hi!  You can solve this problem using asynchronus queue. Check this one Fast Asynchronous Re-indexing http://mirasvit.com/magento-extensions/magento-asynchronous-reindex.html. After each product/category save this extension move reindex task to queue and process this queue as background process in cron.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top