The 2026 Drupal Business Survey is open. Your response will help shape the future of the Drupal business ecosystem.Problem
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.
| Comment | File | Size | Author |
|---|---|---|---|
| View menu but why DB insert delete commerce data 2.jpg | 469.28 KB | ng.ahchi |
Comments
Comment #1
bojanz commentedThis 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?
Comment #2
ng.ahchi commentedI 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.
Comment #3
ng.ahchi commentedI 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
then
- 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.
Thanks!
Comment #4
lsolesen commentedThis must be a cart refresh. If you still experience the issue, please reopen.