• 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.