Slow query

Viewing 1 replies (of 1 total)
  • Thread Starter Cellard

    (@cellard)

    My temporary solution is to modify the query, so it isn’t use current_time(), but date(‘Y-m-d 00:00:00’) instead. Then the rating and query itself are changed one time per day. Database server caches the query and returns the result immediately.

Viewing 1 replies (of 1 total)
  • The topic ‘Slow query’ is closed to new replies.