Low performance with big table logs
-
Hi
Table mail_bank_logs dont have any index, but statistic queries are used “status” and “timestamp” fields. Please add index status + timestamp for better perfomance.
Currently all statistic query use Full table scan. And with 500K log, 12 queries are take about 20 seconds, with index – less then 0.2.
- The topic ‘Low performance with big table logs’ is closed to new replies.