I have magento version 220.127.116.11, and I have greater than 30000 products in my store. My magento databse size raise to 3GB approximate.
For database optimization What I already did :
1) clean log tables
But still database size is 2.7 GB.
When I checked products tables, these have multiple entry for one product corresponding to store and customer group.
For Example : I have 4 store and 6 customer groups then there are total 24 rows for one product in table
Is there any way to set global scope for all customer groups so that there will be only 4 rows in
Or any other way to optimize products tables like