Monday 25 November 2019

Mysql database query very slow with huge data / rows using CREATE INDEX in PHP


CREATE INDEX visitorhistory_store_created_at_index ON visitorhistory (store, created_at);

The reference use: https://blog.nodeswat.com/making-slow-queries-fast-with-composite-indexes-in-mysql-eb452a8d6e46

No comments:

Post a Comment