Edit History

Hello @razaro , I really appreciate your response.

Quote

How many products/categories do you have ?

37K products and 243 categories

Quote

What hosting you are on and what kind of server it is ?

Hostinger's professional plan with 140 GB SSD, 6 GB RAM, 4 CPU Cores, 2X Speed Boost, Cloudflare Integration

https://www.hostinger.in/cloud-hosting

Quote

Do you have some voucher module or just lot of discounts/vouchers created ?

I have 88772 cart rules and no module

Quote

Please check your database directly, like with phpMyAdmin and see what are largest size tables?

Top 5 tables with size

Quote

I saw few times cart_rule_combination tables that are over 10GB

As per phpmyadmin cart_rule_combination is 6.5 MB in size

Hello @razaro , I really appreciate your response.

Quote

How many products/categories do you have ?

37K products and 243 categories

Quote

What hosting you are on and what kind of server it is ?

Hostinger's professional plan with 140 GB SSD, 6 GB RAM, 4 CPU Cores, 2X Speed Boost, Cloudflare Integration

https://www.hostinger.in/cloud-hosting

Quote

Do you have some voucher module or just lot of discounts/vouchers created ?

I have 88772 cart rules and no module

Quote

Please check your database directly, like with phpMyAdmin and see what are largest size tables?

Top 5 tables with size

Quote

I saw few times cart_rule_combination tables that are over 10GB

As per phpmyadmin cart_rule_combination is 6.5 MB in size