An international merchant is complaining that changes are taking too long to be reflected on the frontend after a full product import. Thinking it may be database issues, the Adobe Commerce developer collects the following entity counts;
* Categories: 900
* Products: 300k
* Customers: 700k
* Customer groups : 106
* Orders :1600k
* Invoices: 500k
* Creditmemos: 50k
* Websites: 15
* Stores : 45
What is a probable cause for this?