It is very strange that a lot of unrelated DB insert / update / delete statements when viewing the menu link config. Please refer to the attached image.

I don't have any data issue yet, but those DB statements may cause performance issue also.


bojanz’s picture

Category:bug» support

This looks like the cart refresh process.
The cart refresh only hits the DB if something has changed (a line item has been dropped prices have changed, etc).
Do you have any pricing rules that would trigger such a price change?

ng.ahchi’s picture

I have two custom rules that will be triggered by the event "Calculating the sell price of a product".
One with action : "Multiply the unit price by some amount",
another one with action : "Convert the unit price to a different currency".

I have just tried to disabe those two pricing rules, but same result.

As you can see in the image that that I am viewing the menu link config in Admin mode, so it is very strange that the system will trigger any event relate / update to the Cart.

ng.ahchi’s picture

I have just tried a fresh install of Commerce Kickstart 7.x-2.4, same problem.

I have
- install Devel module 7.x-1.3
- install Administration menu module 7.x-3.0-rc4
- install Drupal for Firebug 7.x-1.4

Visit [admin/structure/menu/item/15/edit]
Seems OK, no abnormal DB update / insert / delete statements

- add "Product 1" to Cart
Visit [admin/structure/menu/item/15/edit] again
those DB update / insert / delete statements appear

- remove "Product 1" from Cart
Visit [admin/structure/menu/item/15/edit] again
those DB update / insert / delete statements appear

Visit [product-category/sample-category-1], [product-category/sample-category-2]
those DB update / insert / delete statements appear

But some pages seems OK, e.g. Front page, [admin/commerce], [admin/structure/menu/manage/user-menu]

Hope the about information can help narrow the scope for trouble-shooting.


lsolesen’s picture

Priority:Major» Normal
Issue summary:View changes
Status:Active» Closed (works as designed)
Issue tags:-data, -frontend performance

This must be a cart refresh. If you still experience the issue, please reopen.