Hello @christopher_oliver,
Greetings of the day!
This facility is provided by default Magento. It is possible due to cron is running. It might be possible that the cron is running several times and the same data is loading multiple times. This can be one of the reasons for your table's big size.
Why this table? then here is the and that we no longer need to determine the total of all the orders to see which products are sold the most. By the variety of aggregation data, we’re able to get the most popular products not only from the beginning but for each specific day, month, or year.
This is a default Magento 2 table so you cannot remove it. But you can delete all the data from the table through the following command.
TRUNCATE TABLE sales_bestsellers_aggregated_daily;
TRUNCATE TABLE sales_bestsellers_aggregated_monthly;
TRUNCATE TABLE sales_bestsellers_aggregated_yearly;
ALTER TABLE sales_bestsellers_aggregated_daily AUTO_INCREMENT=1;
ALTER TABLE sales_bestsellers_aggregated_monthly AUTO_INCREMENT=1;
ALTER TABLE sales_bestsellers_aggregated_yearly AUTO_INCREMENT=1;
SET FOREIGN_KEY_CHECKS=1;
Hope this will help you to solve your problem.
If not, feel free to contact us.
Worked?
Click KUDOS and accept as a solution.
Thank you!
