report_viewed_product_index stores the page visits of every users against their user ids.
After 1 year of user, when users have huge data of page views product detail page is slower for some users.
Any kind of help would be highly appreciated.
I have enabled query log on server, and observed this:
- When I open product page there are 6048 queries
- After truncating table
report_viewed_product_indexthe queries on product page are just 820
- Note: In both cases, query count on
report_viewed_product_indexare just 5