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

Page 2 of 7
Saving Products Very Slow After Upgrade to 1.3.0
 
sieppl
Jr. Member
 
Total Posts:  12
Joined:  2009-04-14
 
hofacker - 20 April 2009 09:38 PM

I’m having the exact same problem.

On one machine (running 1.3.1) it’s no problem. Takes about 8 - 10 seconds (very old testing machine - running on WAMP-server, only the test DB).

On my laptop (which is like one year old) it’s gone to an incredible slowdown. 60 seconds is nothing! Duplicating items is a disaster… (running 1.3.1 on WAMP-server as well)

I will try some other things to try to find out, why it is, like it is. I’m glad I’m not the only one.

Hi! Did you upgrade both or is the faster magento version (on the very old testing machine) a fresh install?
Cheers, Sebastian

 
Magento Community Magento Community
Magento Community
Magento Community
 
hofacker
Jr. Member
 
Total Posts:  13
Joined:  2009-04-08
 

It was a fresh install with a new test-database. I copied the database over to my laptop added some (6) products, which took my like 1,5 hours (no internet available at that time, so not knowing there was something wrong).

I’m now trying some suggestions found it the other threads (deleting wholesale-group and all test items). but the deleting of the test-tems takes already like 15 minutes (120 items).

Now with 6 items left, it takes 25 seconds to save an item (without even editing one thing). Still way too long…

-->

After refreshing everything in ‘Cache-management’ (all cache is turned off), rebuilding and turning on Flat Catalog/Product, it still takes 20 seconds to save an item…

-->

I delete the old price-rules and again the speed went up a bit (well percentagewise a lot). It now takes about 13 seconds.

I’ve also changed some settings in my local mySQL according to this site: http://www.crucialwebhost.com/blog/improving-magento-speed-and-performance-with-mysql-query-cache

But that didn’t seem to help on my backend saving problem. Frontend is quicker than ever though…

 
Magento Community Magento Community
Magento Community
Magento Community
 
robbo23
Sr. Member
 
Total Posts:  81
Joined:  2008-10-20
 

It is strange that you can take the same database, import it into 2 different domains, each with the same setup, and get wildly contrasting speeds. We had this situation even though the domains were on the same server.

We decided the only way forwards would be to rebuild the site because the live site has slowed down to over 2 minutes now to save a product.

We exported the products from System / Import/Export / Profiles and noticed that there were attribute errors on some of the products. We imported the products into a new database, recreated the attributes and categories and are currently in the process of rebuilding. There has been a slight slowdown in performance but it is currently taking 10 seconds to save a product instead of 60 - 120, so it’s a big improvement.

On closer inspection of the attributes we found that on one of them there were 2 options that had both been given the same position, so this was probably causing problems. We think some of the problems stem from when one of the attributes was changed on the test site. We had created an attribute with a list of options and then created products using those attributes. Then we needed to add some more options to the attribute. Instead of adding the new options to the end of the existing list of options we tried to position them so they would still be in numerical order in the dropdown box. This caused a lot of problems and we had to put the options back in the original order. It seems that some products never recovered from this.

It was only ever when editing products that we had a problem with speed and that’s what prompted us to look in this area.

I’m sure there are lots of other factors affecting speed but if you are having problems with saving products it might be worth exporting your products to see if it reports any errors.

What we are doing is no quick fix - we are having to upload each of the images again for example - but if we end up with speeds of 10 - 15 seconds instead of 60 - 120 it will be worth it in the long run.

 
Magento Community Magento Community
Magento Community
Magento Community
 
sieppl
Jr. Member
 
Total Posts:  12
Joined:  2009-04-14
 

I hope this problem is picked up by the magento core team soon.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Loic_LC
Sr. Member
 
Avatar
Total Posts:  194
Joined:  2007-12-19
Paris, France
 

I have the exact same problem
slow (45s + )on editing products after upgrading to V1.3.1
I’m on VPS hosting.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Loic_LC
Sr. Member
 
Avatar
Total Posts:  194
Joined:  2007-12-19
Paris, France
 

Considering this seems to affect many of us and it’s well documented thanks to the tests of robbo23, I’ve reported this as a bug (#13066) with a link to this thread.

 
Magento Community Magento Community
Magento Community
Magento Community
 
thE_iNviNciblE
Sr. Member
 
Avatar
Total Posts:  220
Joined:  2008-01-09
Oldenburg
 
sieppl - 21 April 2009 04:23 AM

I hope this problem is picked up by the magento core team soon.

yes.. i can confirm the behaviour, that saving an product is really slow… also the importing of products....

 
Magento Community Magento Community
Magento Community
Magento Community
 
robbo23
Sr. Member
 
Total Posts:  81
Joined:  2008-10-20
 

Hi Guys,

Just noticed something you might want to try…

I added 2 catalog price rules and the speed slowed down by a further 10 - 20 seconds. I deleted them and replaced them with shopping cart price rules and the speed went back to what it was before (currently about 10 seconds on the site we are rebuilding).

Might be worth trying to see if this helps at all.

 
Magento Community Magento Community
Magento Community
Magento Community
 
coldlamper
Member
 
Total Posts:  35
Joined:  2009-02-01
NC, USA
 

There are just too many queries to add /delete or whatever to a product. 
Here is my mysql log for adding 1 product

090420 11:57:19 7 Query SELECT `main_table`.* FROM `eav_entity_type` AS `main_table`
7 Query SELECT `main_table`.* FROM `eav_attribute` AS `main_table` WHERE (main_table.entity_type_id=’4’) AND (main_table.attribute_code IN(’entity_id’, ‘entity_type_id’, ‘attribute_set_id’, ‘type_id’, ‘created_at’, ‘updated_at’))
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’entity_id’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’entity_type_id’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’attribute_set_id’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’type_id’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’created_at’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’updated_at’) AND (entity_type_id=’4’)
7 Query SELECT `main_table`.*, `entity_attribute`.* FROM `eav_attribute` AS `main_table`
INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id=main_table.attribute_id WHERE (main_table.entity_type_id=’4’) AND (entity_attribute.attribute_set_id=4) ORDER BY sort_order ASC
7 Query SELECT `main_table`.* FROM `eav_attribute` AS `main_table` WHERE (main_table.entity_type_id=’4’) AND (main_table.attribute_code IN(’name’, ‘price’, ‘meta_title’, ‘image’, ‘custom_design’, ‘description’, ‘special_price’, ‘meta_keyword’, ‘small_image’, ‘custom_design_from’, ‘short_description’, ‘special_from_date’, ‘meta_description’, ‘thumbnail’, ‘custom_design_to’, ‘sku’, ‘special_to_date’, ‘media_gallery’, ‘custom_layout_update’, ‘shoesize’, ‘cost’, ‘gallery’, ‘options_container’, ‘weight’, ‘tax_class_id’, ‘old_id’, ‘manufacturer’, ‘tier_price’, ‘minimal_price’, ‘color’, ‘disable_googlecheckout’, ‘news_from_date’, ‘price_view’, ‘news_to_date’, ‘status’, ‘url_key’, ‘url_path’, ‘visibility’, ‘gift_message_available’, ‘category_ids’, ‘required_options’, ‘has_options’, ‘image_label’, ‘small_image_label’, ‘thumbnail_label’, ‘price_type’, ‘sku_type’, ‘weight_type’, ‘shipment_type’, ‘links_purchased_separately’, ‘samples_title’, ‘links_title’))
7 Query SELECT `entity`.`attribute_id`, `entity`.`attribute_set_id`, `entity`.`attribute_group_id`, `entity`.`sort_order`, `group`.`sort_order` AS `group_sort_order` FROM `eav_entity_attribute` AS `entity`
LEFT JOIN `eav_attribute_group` AS `group` ON entity.attribute_group_id=group.attribute_group_id WHERE (attribute_id IN (’90’, ‘76’, ‘64’, ‘86’, ‘87’, ‘88’, ‘89’, ‘57’, ‘462’, ‘79’, ‘464’, ‘93’, ‘70’, ‘94’, ‘470’, ‘472’, ‘66’, ‘73’, ‘69’, ‘68’, ‘67’, ‘84’, ‘56’, ‘77’, ‘78’, ‘74’, ‘91’, ‘60’, ‘465’, ‘468’, ‘92’, ‘471’, ‘469’, ‘491’, ‘58’, ‘59’, ‘466’, ‘71’, ‘95’, ‘62’, ‘61’, ‘63’, ‘80’, ‘81’, ‘72’, ‘96’, ‘75’, ‘82’, ‘83’, ‘85’, ‘65’, ‘467’))
090420 11:57:20 7 Query START TRANSACTION
090420 11:57:22 7 Query SELECT `main_table`.*, `entity_attribute`.* FROM `eav_attribute` AS `main_table`
INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id=main_table.attribute_id WHERE (main_table.entity_type_id=’4’) AND (entity_attribute.attribute_set_id=4) ORDER BY sort_order ASC
7 Query select entity_id from catalog_product_entity where sku=’1AALIPGSPH10000’
7 Query SELECT `main_table`.* FROM `eav_attribute` AS `main_table` WHERE (main_table.entity_type_id=’3’)
7 Query SELECT `entity`.`attribute_id`, `entity`.`attribute_set_id`, `entity`.`attribute_group_id`, `entity`.`sort_order`, `group`.`sort_order` AS `group_sort_order` FROM `eav_entity_attribute` AS `entity`
LEFT JOIN `eav_attribute_group` AS `group` ON entity.attribute_group_id=group.attribute_group_id WHERE (attribute_id IN (’44’, ‘46’, ‘55’, ‘48’, ‘49’, ‘50’, ‘51’, ‘53’, ‘34’, ‘39’, ‘35’, ‘32’, ‘41’, ‘40’, ‘54’, ‘38’, ‘37’, ‘36’, ‘31’, ‘52’, ‘42’, ‘45’, ‘43’, ‘33’, ‘47’))
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’entity_type_id’) AND (entity_type_id=’3’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’attribute_set_id’) AND (entity_type_id=’3’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’created_at’) AND (entity_type_id=’3’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’updated_at’) AND (entity_type_id=’3’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’parent_id’) AND (entity_type_id=’3’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’increment_id’) AND (entity_type_id=’3’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’entity_id’) AND (entity_type_id=’3’)
7 Query SELECT `catalog_category_entity`.`entity_id` FROM `catalog_category_entity` WHERE (entity_id IN(’154’))
090420 11:57:23 7 Query SELECT `main_table`.* FROM `eav_attribute` AS `main_table` WHERE (main_table.entity_type_id=’4’)
7 Query SELECT `entity`.`attribute_id`, `entity`.`attribute_set_id`, `entity`.`attribute_group_id`, `entity`.`sort_order`, `group`.`sort_order` AS `group_sort_order` FROM `eav_entity_attribute` AS `entity`
LEFT JOIN `eav_attribute_group` AS `group` ON entity.attribute_group_id=group.attribute_group_id WHERE (attribute_id IN (’90’, ‘76’, ‘64’, ‘86’, ‘87’, ‘88’, ‘89’, ‘57’, ‘462’, ‘79’, ‘464’, ‘93’, ‘70’, ‘94’, ‘470’, ‘472’, ‘66’, ‘73’, ‘69’, ‘68’, ‘67’, ‘84’, ‘56’, ‘77’, ‘78’, ‘74’, ‘91’, ‘60’, ‘465’, ‘468’, ‘92’, ‘471’, ‘469’, ‘491’, ‘58’, ‘59’, ‘466’, ‘71’, ‘95’, ‘62’, ‘61’, ‘63’, ‘80’, ‘81’, ‘72’, ‘96’, ‘75’, ‘82’, ‘83’, ‘85’, ‘65’, ‘467’))
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’store_id’) AND (entity_type_id=’4’)
7 Query DESCRIBE `catalog_product_entity`
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’decksize’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’type_has_options’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’type_has_required_options’) AND (entity_type_id=’4’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’parent_id’) AND (entity_type_id=’4’)
7 Query INSERT INTO `catalog_product_entity` (`category_ids`, `attribute_set_id`, `sku`, `type_id`, `has_options`, `entity_type_id`, `entity_id`, `created_at`, `updated_at`) VALUES (’154’, ‘4’, ‘1AALIPGSPH10000’, ‘simple’, ‘’, ‘4’, ‘’, ‘2009-04-20 15:57:22’, ‘2009-04-20 15:57:22’)
7 Query INSERT INTO `catalog_product_entity_decimal` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘60’, ‘3.900000’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_decimal` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘65’, ‘0.120000’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_text` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘57’, ‘Alien 1\\\” Phillips Hardware Single Set’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_text` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘58’, ‘Alien 1\\\” Phillips Hardware Single Set’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘56’, ‘Alien 1\\\” Phillips Hardware Single Set’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_int` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘66’, ‘173’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_int` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘81’, ‘2’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_int` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘80’, ‘1’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘72’, ‘/1/A/1AALIPGSPH10000_8.gif’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘71’, ‘/1/A/1AALIPGSPH10000_8.gif’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘70’, ‘/1/A/1AALIPGSPH10000_8.gif’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘94’, ‘’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘95’, ‘’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘96’, ‘’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘91’, ‘container2’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘82’, ‘alien-1-phillips-hardware-single-set’, ‘0’)
7 Query INSERT INTO `catalog_product_entity_int` (`entity_id`, `entity_type_id`, `attribute_id`, `value`, `store_id`) VALUES (’7’, ‘4’, ‘85’, ‘4’, ‘0’)
7 Query SELECT `catalog_product_website`.* FROM `catalog_product_website` WHERE (product_id=’7’)
7 Query INSERT INTO `catalog_product_website` (`product_id`, `website_id`) VALUES (’7’, ‘1’)
7 Query insert into catalog_category_product
(category_id, product_id, position) values (154,7,0)
7 Query DELETE FROM `catalog_category_product_index` WHERE (product_id=’7’)
7 Query SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id IN (’154’))
7 Query SELECT `catalog_category_product`.`category_id`, `catalog_category_product`.`position` FROM `catalog_category_product` WHERE (product_id=7)
7 Query SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE (entity_id IN (’1’, ‘2’, ‘152’, ‘153’, ‘154’)) ORDER BY `level` ASC, `path` ASC
7 Query SELECT
s.store_id, s.website_id, c.path AS root_path
FROM
core_store AS s,
core_store_group AS sg,
catalog_category_entity AS c
WHERE
sg.group_id=s.group_id
AND c.entity_id=sg.root_category_id
7 Query DELETE FROM `catalog_category_product_index` WHERE (category_id=1 AND store_id=1 AND product_id IN (’7’))
7 Query DELETE FROM `catalog_category_product_index` WHERE (category_id=2 AND store_id=1 AND product_id IN (’7’))
7 Query INSERT INTO catalog_category_product_index
(`category_id`, `product_id`, `position`, `is_parent`, `store_id`, `visibility`)
SELECT
2,
cp.product_id,
cp.position,
2=cp.category_id as is_parent,
1,
IFNULL(t_v.value, t_v_default.value)
FROM
catalog_category_product AS cp
INNER JOIN catalog_product_website AS pw
ON pw.product_id=cp.product_id AND pw.website_id=1
INNER JOIN catalog_product_entity_int AS `t_v_default`
ON (t_v_default.entity_id = cp.product_id)
AND (t_v_default.attribute_id=’85’)
AND t_v_default.store_id=0
LEFT JOIN catalog_product_entity_int AS `t_v`
ON (t_v.entity_id = cp.product_id)
AND (t_v.attribute_id=’85’)
AND (t_v.store_id=’1’)
INNER JOIN catalog_product_entity_int AS `t_s_default`
ON (t_s_default.entity_id = cp.product_id)
AND (t_s_default.attribute_id=’80’)
AND t_s_default.store_id=0
LEFT JOIN catalog_product_entity_int AS `t_s`
ON (t_s.entity_id = cp.product_id)
AND (t_s.attribute_id=’80’)
AND (t_s.store_id=’1’)
WHERE category_id IN(
SELECT entity_id FROM catalog_category_entity
WHERE entity_id = 2 OR path LIKE ‘1/2/%’)
AND (IFNULL(t_s.value, t_s_default.value)=1)
AND cp.product_id IN (’7’)
GROUP BY product_id
ORDER BY is_parent desc
7 Query DELETE FROM `catalog_category_product_index` WHERE (category_id=152 AND store_id=1 AND product_id IN (’7’))
7 Query INSERT INTO catalog_category_product_index
(`category_id`, `product_id`, `position`, `is_parent`, `store_id`, `visibility`)
SELECT
152,
cp.product_id,
cp.position,
152=cp.category_id as is_parent,
1,
IFNULL(t_v.value, t_v_default.value)
FROM
catalog_category_product AS cp
INNER JOIN catalog_product_website AS pw
ON pw.product_id=cp.product_id AND pw.website_id=1
INNER JOIN catalog_product_entity_int AS `t_v_default`
ON (t_v_default.entity_id = cp.product_id)
AND (t_v_default.attribute_id=’85’)
AND t_v_default.store_id=0
LEFT JOIN catalog_product_entity_int AS `t_v`
ON (t_v.entity_id = cp.product_id)
AND (t_v.attribute_id=’85’)
AND (t_v.store_id=’1’)
INNER JOIN catalog_product_entity_int AS `t_s_default`
ON (t_s_default.entity_id = cp.product_id)
AND (t_s_default.attribute_id=’80’)
AND t_s_default.store_id=0
LEFT JOIN catalog_product_entity_int AS `t_s`
ON (t_s.entity_id = cp.product_id)
AND (t_s.attribute_id=’80’)
AND (t_s.store_id=’1’)
WHERE category_id IN(
SELECT entity_id FROM catalog_category_entity
WHERE entity_id = 152 OR path LIKE ‘1/2/152/%’)
AND (IFNULL(t_s.value, t_s_default.value)=1)
AND cp.product_id IN (’7’)
GROUP BY product_id
ORDER BY is_parent desc
7 Query DELETE FROM `catalog_category_product_index` WHERE (category_id=153 AND store_id=1 AND product_id IN (’7’))
7 Query INSERT INTO catalog_category_product_index
(`category_id`, `product_id`, `position`, `is_parent`, `store_id`, `visibility`)
SELECT
153,
cp.product_id,
cp.position,
153=cp.category_id as is_parent,
1,
IFNULL(t_v.value, t_v_default.value)
FROM
catalog_category_product AS cp
INNER JOIN catalog_product_website AS pw
ON pw.product_id=cp.product_id AND pw.website_id=1
INNER JOIN catalog_product_entity_int AS `t_v_default`
ON (t_v_default.entity_id = cp.product_id)
AND (t_v_default.attribute_id=’85’)
AND t_v_default.store_id=0
LEFT JOIN catalog_product_entity_int AS `t_v`
ON (t_v.entity_id = cp.product_id)
AND (t_v.attribute_id=’85’)
AND (t_v.store_id=’1’)
INNER JOIN catalog_product_entity_int AS `t_s_default`
ON (t_s_default.entity_id = cp.product_id)
AND (t_s_default.attribute_id=’80’)
AND t_s_default.store_id=0
LEFT JOIN catalog_product_entity_int AS `t_s`
ON (t_s.entity_id = cp.product_id)
AND (t_s.attribute_id=’80’)
AND (t_s.store_id=’1’)
WHERE category_id IN(
SELECT entity_id FROM catalog_category_entity
WHERE entity_id = 153 OR path LIKE ‘1/2/152/153/%’)
AND (IFNULL(t_s.value, t_s_default.value)=1)
AND cp.product_id IN (’7’)
GROUP BY product_id
ORDER BY is_parent desc
7 Query DELETE FROM `catalog_category_product_index` WHERE (category_id=154 AND store_id=1 AND product_id IN (’7’))
7 Query INSERT INTO catalog_category_product_index
(`category_id`, `product_id`, `position`, `is_parent`, `store_id`, `visibility`)
SELECT
154,
cp.product_id,
cp.position,
154=cp.category_id as is_parent,
1,
IFNULL(t_v.value, t_v_default.value)
FROM
catalog_category_product AS cp
INNER JOIN catalog_product_website AS pw
ON pw.product_id=cp.product_id AND pw.website_id=1
INNER JOIN catalog_product_entity_int AS `t_v_default`
ON (t_v_default.entity_id = cp.product_id)
AND (t_v_default.attribute_id=’85’)
AND t_v_default.store_id=0
LEFT JOIN catalog_product_entity_int AS `t_v`
ON (t_v.entity_id = cp.product_id)
AND (t_v.attribute_id=’85’)
AND (t_v.store_id=’1’)
INNER JOIN catalog_product_entity_int AS `t_s_default`
ON (t_s_default.entity_id = cp.product_id)
AND (t_s_default.attribute_id=’80’)
AND t_s_default.store_id=0
LEFT JOIN catalog_product_entity_int AS `t_s`
ON (t_s.entity_id = cp.product_id)
AND (t_s.attribute_id=’80’)
AND (t_s.store_id=’1’)
WHERE category_id IN(
SELECT entity_id FROM catalog_category_entity
WHERE entity_id = 154 OR path LIKE ‘1/2/152/153/154/%’)
AND (IFNULL(t_s.value, t_s_default.value)=1)
AND cp.product_id IN (’7’)
GROUP BY product_id
ORDER BY is_parent desc
7 Query DELETE FROM `catalog_product_enabled_index` WHERE (product_id=7 AND store_id=1)
7 Query INSERT INTO catalog_product_enabled_index
SELECT
7, 1, IFNULL(t_v.value, t_v_default.value)
FROM
catalog_product_entity_int AS t_v_default
LEFT JOIN catalog_product_entity_int AS `t_v`
ON (t_v.entity_id = t_v_default.entity_id)
AND (t_v.attribute_id=’85’)
AND (t_v.store_id=’1’)
INNER JOIN catalog_product_entity_int AS `t_s_default`
ON (t_s_default.entity_id = t_v_default.entity_id)
AND (t_s_default.attribute_id=’80’)
AND t_s_default.store_id=0
LEFT JOIN catalog_product_entity_int AS `t_s`
ON (t_s.entity_id = t_v_default.entity_id)
AND (t_s.attribute_id=’80’)
AND (t_s.store_id=’1’)
WHERE
t_v_default.entity_id=7
AND t_v_default.attribute_id=’85’ AND t_v_default.store_id=0
AND (IFNULL(t_s.value, t_s_default.value)=1)
7 Query INSERT INTO `catalog_product_entity_media_gallery` (`entity_id`, `attribute_id`, `value`) VALUES (’7’, ‘73’, ‘/1/A/1AALIPGSPH10000_8.gif’)
7 Query DELETE FROM `catalog_product_entity_media_gallery_value` WHERE (value_id = 1 AND store_id = 0)
7 Query INSERT INTO `catalog_product_entity_media_gallery_value` (`value_id`, `label`, `position`, `disabled`, `store_id`) VALUES (’1’, ‘’, ‘1’, ‘0’, ‘0’)
7 Query DELETE FROM `catalog_product_entity_tier_price` WHERE (entity_id=’7’)
090420 11:57:24 7 Query SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (eav_entity_type.entity_type_code=’catalog_category’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’is_active’) AND (entity_type_id=’3’)
7 Query SELECT `main_table`.`entity_id`, `main_table`.`parent_id`, IFNULL(c.value, d.value) AS `is_active`, `main_table`.`path` FROM `catalog_category_entity` AS `main_table`
LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = ‘32’ AND d.store_id = 0 AND d.entity_id = main_table.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = ‘32’ AND c.store_id = ‘’ AND c.entity_id = main_table.entity_id WHERE (main_table.entity_id IN(’2’))
7 Query SELECT `e`.`entity_id`, `e`.`category_ids` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_website` AS `w` ON e.entity_id=w.product_id AND w.website_id=’1’ WHERE (e.entity_id>0) AND (e.entity_id IN(’7’)) ORDER BY `e`.`entity_id` ASC LIMIT 250
7 Query SELECT `t1`.`entity_id`, IFNULL(t2.value, t1.value) AS `value` FROM `catalog_product_entity_varchar` AS `t1`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id AND t2.store_id=’1’ WHERE (t1.store_id = 0) AND (t1.attribute_id = ‘56’) AND (t1.entity_id IN(7))
7 Query SELECT `catalog_product_entity_varchar`.`entity_id`, `catalog_product_entity_varchar`.`value` FROM `catalog_product_entity_varchar` WHERE (attribute_id = ‘82’) AND (store_id=0) AND (entity_id IN(7))
7 Query SELECT `t1`.`entity_id`, IFNULL(t2.value, t1.value) AS `value` FROM `catalog_product_entity_varchar` AS `t1`
LEFT JOIN `catalog_product_entity_varchar` AS `t2` ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id AND t2.store_id=’1’ WHERE (t1.store_id = 0) AND (t1.attribute_id = ‘83’) AND (t1.entity_id IN(7))
7 Query SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (eav_entity_type.entity_type_code=’catalog_category’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’is_active’) AND (entity_type_id=’3’)
7 Query SELECT `main_table`.`entity_id`, `main_table`.`parent_id`, IFNULL(c.value, d.value) AS `is_active`, `main_table`.`path` FROM `catalog_category_entity` AS `main_table`
LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = ‘32’ AND d.store_id = 0 AND d.entity_id = main_table.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = ‘32’ AND c.store_id = ‘1’ AND c.entity_id = main_table.entity_id WHERE (main_table.entity_id IN(’154’))
7 Query SELECT `t1`.`entity_id`, IFNULL(t2.value, t1.value) AS `value` FROM `catalog_category_entity_varchar` AS `t1`
LEFT JOIN `catalog_category_entity_varchar` AS `t2` ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id AND t2.store_id=’1’ WHERE (t1.store_id = 0) AND (t1.attribute_id = ‘31’) AND (t1.entity_id IN(154))
7 Query SELECT `catalog_category_entity_varchar`.`entity_id`, `catalog_category_entity_varchar`.`value` FROM `catalog_category_entity_varchar` WHERE (attribute_id = ‘33’) AND (store_id=0) AND (entity_id IN(154))
7 Query SELECT `t1`.`entity_id`, IFNULL(t2.value, t1.value) AS `value` FROM `catalog_category_entity_varchar` AS `t1`
LEFT JOIN `catalog_category_entity_varchar` AS `t2` ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id AND t2.store_id=’1’ WHERE (t1.store_id = 0) AND (t1.attribute_id = ‘47’) AND (t1.entity_id IN(154))
7 Query SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (store_id=’1’) AND (is_system=1) AND (product_id IN(’7’))
7 Query SELECT `eav_entity_type`.* FROM `eav_entity_type` WHERE (eav_entity_type.entity_type_code=’catalog_category’)
7 Query SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (eav_attribute.attribute_code=’is_active’) AND (entity_type_id=’3’)
7 Query SELECT `main_table`.`entity_id`, `main_table`.`parent_id`, IFNULL(c.value, d.value) AS `is_active`, `main_table`.`path` FROM `catalog_category_entity` AS `main_table`
LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = ‘32’ AND d.store_id = 0 AND d.entity_id = main_table.entity_id
LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = ‘32’ AND c.store_id = ‘1’ AND c.entity_id = main_table.entity_id WHERE (main_table.entity_id IN(’2’))
7 Query SELECT `t1`.`entity_id`, IFNULL(t2.value, t1.value) AS `value` FROM `catalog_category_entity_varchar` AS `t1`
LEFT JOIN `catalog_category_entity_varchar` AS `t2` ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id AND t2.store_id=’1’ WHERE (t1.store_id = 0) AND (t1.attribute_id = ‘31’) AND (t1.entity_id IN(2))
7 Query SELECT `catalog_category_entity_varchar`.`entity_id`, `catalog_category_entity_varchar`.`value` FROM `catalog_category_entity_varchar` WHERE (attribute_id = ‘33’) AND (store_id=0) AND (entity_id IN(2))
7 Query SELECT `t1`.`entity_id`, IFNULL(t2.value, t1.value) AS `value` FROM `catalog_category_entity_varchar` AS `t1`
LEFT JOIN `catalog_category_entity_varchar` AS `t2` ON t1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id AND t2.store_id=’1’ WHERE (t1.store_id = 0) AND (t1.attribute_id = ‘47’) AND (t1.entity_id IN(2))
7 Query SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (store_id=’1’) AND (request_path=’skate-shop/accessories/hardware/alien-1-phillips-hardware-single-set.html’)
7 Query INSERT INTO `core_url_rewrite` (`store_id`, `category_id`, `product_id`, `id_path`, `request_path`, `target_path`, `is_system`) VALUES (’1’, ‘154’, ‘7’, ‘product/7/154’, ‘skate-shop/accessories/hardware/alien-1-phillips-hardware-single-set.html’, ‘catalog/product/view/id/7/category/154’, ‘1’)
7 Query SELECT `core_url_rewrite`.* FROM `core_url_rewrite` WHERE (store_id=’1’) AND (request_path=’alien-1-phillips-hardware-single-set.html’)
7 Query INSERT INTO `core_url_rewrite` (`store_id`, `category_id`, `product_id`, `id_path`, `request_path`, `target_path`, `is_system`) VALUES (’1’, NULL, ‘7’, ‘product/7’, ‘alien-1-phillips-hardware-single-set.html’, ‘catalog/product/view/id/7’, ‘1’)
7 Query SELECT `catalog_product_entity_varchar`.* FROM `catalog_product_entity_varchar` WHERE (entity_type_id=’4’) AND (attribute_id=’83’) AND (store_id=0) AND (entity_id=’7’)
7 Query INSERT INTO `catalog_product_entity_varchar` (`entity_type_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES (’4’, ‘83’, ‘0’, ‘7’, ‘alien-1-phillips-hardware-single-set.html’)
090420 11:57:26 7 Query DELETE FROM `catalogsearch_fulltext` WHERE (store_id=’1’) AND (product_id IN(’7’))
7 Query SELECT `eav_attribute`.`attribute_code` FROM `eav_attribute` WHERE (entity_type_id=’4’) AND (is_searchable=1)
7 Query SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`sku` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_website` AS `website` ON website.product_id=e.entity_id AND website.website_id=’1’ WHERE (e.entity_id IN(’7’)) AND (e.entity_id>0) ORDER BY `e`.`entity_id` ASC LIMIT 100
7 Query (SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IFNULL(t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_int` AS `t_default`
LEFT JOIN `catalog_product_entity_int` AS `t_store` ON t_default.entity_id=t_store.entity_id AND t_default.attribute_id=t_store.attribute_id AND t_store.store_id=’1’ WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(76, 66, 491, 80, 81, 85)) AND (t_default.entity_id IN(’7’)))UNION(SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IFNULL(t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_default`
LEFT JOIN `catalog_product_entity_varchar` AS `t_store` ON t_default.entity_id=t_store.entity_id AND t_default.attribute_id=t_store.attribute_id AND t_store.store_id=’1’ WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(56)) AND (t_default.entity_id IN(’7’)))UNION(SELECT `t_default`.`entity_id`, `t_default`.`attribute_id`, IFNULL(t_store.value, t_default.value) AS `value` FROM `catalog_product_entity_text` AS `t_default`
LEFT JOIN `catalog_product_entity_text` AS `t_store` ON t_default.entity_id=t_store.entity_id AND t_default.attribute_id=t_store.attribute_id AND t_store.store_id=’1’ WHERE (t_default.store_id=0) AND (t_default.attribute_id IN(57, 58)) AND (t_default.entity_id IN(’7’)))
7 Query SELECT `main_table`.*, `store_default_value`.`value` AS `default_value`, `store_value`.`value` AS `store_value`, IFNULL(store_value.value,store_default_value.value) AS `value` FROM `eav_attribute_option` AS `main_table`
INNER JOIN `eav_attribute_option_value` AS `store_default_value` ON store_default_value.option_id=main_table.option_id
LEFT JOIN `eav_attribute_option_value` AS `store_value` ON store_value.option_id=main_table.option_id AND store_value.store_id=’default’ WHERE (main_table.attribute_id=’66’) AND (store_default_value.store_id=0) ORDER BY main_table.sort_order ASC, store_default_value.value ASC, main_table.sort_order ASC, store_default_value.value ASC
090420 11:57:27 7 Query SELECT `main_table`.* FROM `tax_class` AS `main_table` WHERE (class_type = ‘PRODUCT’)
7 Query REPLACE INTO `catalogsearch_fulltext` VALUES(7,’1’,’1AALIPGSPH10000 Alien Workshop Enabled Taxable Goods Alien 1\\\” Phillips Hardware Single Set Alien 1\\\” Phillips Hardware Single Set Alien 1\\\” Phillips Hardware Single Set’)
7 Query SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`sku` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_website` AS `website` ON website.product_id=e.entity_id AND website.website_id=’1’ WHERE (e.entity_id IN(’7’)) AND (e.entity_id>’7’) ORDER BY `e`.`entity_id` ASC LIMIT 100
7 Query UPDATE `catalogsearch_query` SET `is_processed` = ‘0’
7 Query TRUNCATE TABLE catalogsearch_result
7 Query SELECT `tags`.`tag_code`, `tags`.`tag_id` FROM `catalogindex_aggregation_tag` AS `tags` WHERE (tags.tag_code IN (’SEARCH_QUERY’))
7 Query DELETE FROM `catalogindex_aggregation` WHERE (aggregation_id IN (SELECT `catalogindex_aggregation_to_tag`.`aggregation_id` FROM `catalogindex_aggregation_to_tag` WHERE (tag_id IN (’73’))))
7 Query UPDATE `catalogsearch_query` SET `is_processed` = ‘0’
7 Query TRUNCATE TABLE catalogsearch_result
7 Query SELECT `tags`.`tag_code`, `tags`.`tag_id` FROM `catalogindex_aggregation_tag` AS `tags` WHERE (tags.tag_code IN (’SEARCH_QUERY’))
7 Query DELETE FROM `catalogindex_aggregation` WHERE (aggregation_id IN (SELECT `catalogindex_aggregation_to_tag`.`aggregation_id` FROM `catalogindex_aggregation_to_tag` WHERE (tag_id IN (’73’))))
7 Query SELECT `e`.`entity_id`, `e`.`type_id` FROM `catalog_product_entity` AS `e` WHERE (entity_id IN(’7’))
7 Query SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (cataloginventory_stock_item.product_id=’7’) AND (stock_id=1)
7 Query SELECT `website_table`.`website_id`, IFNULL(`store_group_table`.`default_store_id`, 0) AS `store_id` FROM `core_website` AS `website_table`
LEFT JOIN `core_store_group` AS `store_group_table` ON `website_table`.`website_id`=`store_group_table`.`website_id` AND `website_table`.`default_group_id`=`store_group_table`.`group_id` WHERE (`website_table`.`website_id` <> 0)
090420 11:57:28 7 Query SELECT `cataloginventory_stock_status`.* FROM `cataloginventory_stock_status` WHERE (product_id=’7’) AND (website_id=1) AND (stock_id=1)
7 Query INSERT INTO `cataloginventory_stock_status` (`product_id`, `website_id`, `stock_id`, `qty`, `stock_status`) VALUES (’7’, ‘1’, ‘1’, ‘0’, ‘1’)
7 Query SELECT `catalog_product_link`.`product_id`, `catalog_product_link`.`linked_product_id` FROM `catalog_product_link` WHERE (linked_product_id=’7’) AND (link_type_id=3)
7 Query SELECT `catalog_product_super_link`.`product_id`, `catalog_product_super_link`.`parent_id` FROM `catalog_product_super_link` WHERE (product_id=’7’)
7 Query SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection`
INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON `tbl_option`.`option_id` = `tbl_selection`.`option_id` WHERE (`tbl_selection`.`product_id`=’7’)
7 Query SELECT `core_flag`.* FROM `core_flag` WHERE (core_flag.flag_code=’catalogindex’)
7 Query SELECT `g`.`product_id` FROM `catalog_product_link` AS `g` WHERE (g.linked_product_id = ‘7’) AND (link_type_id = 3)
7 Query SELECT `c`.`parent_id` FROM `catalog_product_super_link` AS `c` WHERE (c.product_id = ‘7’)
7 Query SELECT `cat`.`path` FROM `catalog_category_entity` AS `cat`
INNER JOIN `catalog_category_product` AS `cat_prod` ON cat.entity_id=cat_prod.category_id AND cat_prod.product_id IN (’7’)
7 Query SELECT `tags`.`tag_code`, `tags`.`tag_id` FROM `catalogindex_aggregation_tag` AS `tags` WHERE (tags.tag_code IN (’catalog_category1’, ‘catalog_category2’, ‘catalog_category152’, ‘catalog_category153’, ‘catalog_category154’))
7 Query DELETE FROM `catalogindex_aggregation` WHERE (aggregation_id IN (SELECT `catalogindex_aggregation_to_tag`.`aggregation_id` FROM `catalogindex_aggregation_to_tag` WHERE (tag_id IN (’1’, ‘154’, ‘155’, ‘156’, ‘153’))))
7 Query COMMIT
7 Query SELECT `cataloginventory_stock_item`.*, `p`.`type_id` FROM `cataloginventory_stock_item`
INNER JOIN `catalog_product_entity` AS `p` ON product_id=p.entity_id WHERE (cataloginventory_stock_item.product_id=’7’) AND (stock_id=1)
7 Query START TRANSACTION
7 Query SELECT `e`.`entity_id`, `e`.`type_id` FROM `catalog_product_entity` AS `e` WHERE (entity_id IN(’7’))
7 Query SELECT `cataloginventory_stock_status`.* FROM `cataloginventory_stock_status` WHERE (product_id=’7’) AND (website_id=1) AND (stock_id=1)
7 Query UPDATE `cataloginventory_stock_status` SET `qty` = ‘0’, `stock_status` = ‘1’ WHERE (product_id=’7’) AND (website_id=’1’) AND (stock_id=’1’)
7 Query SELECT `catalog_product_link`.`product_id`, `catalog_product_link`.`linked_product_id` FROM `catalog_product_link` WHERE (linked_product_id=’7’) AND (link_type_id=3)
7 Query SELECT `catalog_product_super_link`.`product_id`, `catalog_product_super_link`.`parent_id` FROM `catalog_product_super_link` WHERE (product_id=’7’)
7 Query SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection`
INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON `tbl_option`.`option_id` = `tbl_selection`.`option_id` WHERE (`tbl_selection`.`product_id`=’7’)
7 Query DESCRIBE `cataloginventory_stock_item`
7 Query INSERT INTO `cataloginventory_stock_item` (`product_id`, `stock_id`, `qty`, `is_in_stock`) VALUES (’7’, ‘1’, ‘0.000000’, ‘1’)
7 Query COMMIT
090420 11:57:47 7 Quit
8 Quit

Can you even get a server that could handle this?

 
Magento Community Magento Community
Magento Community
Magento Community
 
sieppl
Jr. Member
 
Total Posts:  12
Joined:  2009-04-14
 

shock  shock  shock  shock  shock  shock

 
Magento Community Magento Community
Magento Community
Magento Community
 
thE_iNviNciblE
Sr. Member
 
Avatar
Total Posts:  220
Joined:  2008-01-09
Oldenburg
 

wow a really long statement ...  now i know why to setup mysql with more table cache wink

 
Magento Community Magento Community
Magento Community
Magento Community
 
sieppl
Jr. Member
 
Total Posts:  12
Joined:  2009-04-14
 

-stupid comment deleted-

 
Magento Community Magento Community
Magento Community
Magento Community
 
coldlamper
Member
 
Total Posts:  35
Joined:  2009-02-01
NC, USA
 

Not sure why but I disabled all the caching then did a refresh and adding a product went from 6-8sec to less then 1 sec.  Worked on 2 different servers.

 
Magento Community Magento Community
Magento Community
Magento Community
 
kanixd
Jr. Member
 
Total Posts:  10
Joined:  2008-09-17
 

I’m facing the same issue (slow saving products).

In addition, i’m facing another different issue when I try to save products. I get this error message:

Fatal errorAllowed memory size of 134217728 bytes exhausted (tried to allocate 64 bytesin /usr/home/mydomain.com/magento/app/code/core/Mage/Weee/Model/Mysql4/Tax.php on line 43
And catalog rules don’t work unless I edit one of them and click “Save and Apply”
 
Magento Community Magento Community
Magento Community
Magento Community
 
AllynWA
Jr. Member
 
Total Posts:  28
Joined:  2008-12-02
Allyn, WA
 

Same problem with a WAMP server setup. 465 products. Running on my own server so no hosting issues.

Did an export as was suggested by robbo23 but did not see any errors or anomalies in the exported data. Did the same exercise hofacker suggested with the cache-on/cache-off toggle.

I go into Manage Products and pick a product, modify a single attribute on the product (SKU) to add a single character to it (for test), then hit Save button.

Popup window lasts for maybe a second, but takes 38 seconds for page to refresh back to the list of products. I can see the database get a small 1 - 2 second blip with the data write happens, then there is a blip with the category list is displayed again, but no other data activity during the 38 second waiting period.

Can’t seem to find any other explanations. Nor does it appear anyone else can either?

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 2 of 7