SQL use BEETWEN date() instead of AND '' #4785
Labels
c: Performance
For when we could improve the performance / speed of Matomo.
Enhancement
For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Milestone
I'm using MySQL 5.6
I've noticed most of the query in the archiving phase uses something like
log_link_visit_action.server_time >= 'XXX'
AND log_link_visit_action.server_time <= 'XXX'
So I've made some test and concluded that
server_time BETWEEN date( 'XXX') AND date('XXX')
is a bit faster.
In gist some example
https://gist.github.com/RoyBellingan/9300236
The text was updated successfully, but these errors were encountered: