date

Cache queries with dates

This post is about a small tip regarding queries that include dates in the clause. If you are not careful enough, you might be taking a performance hit.

Let’s suppose you have a database table containing articles (with the same name) and there is a field named publishing_datetime. You can store articles with a future date in that table, so that an article will be auto published when that time comes. Read More…

 Scroll to top