Laravel performance tip:

Be careful with `whereDate()` on large tables.

It looks clean, but it can make your database apply a function to the column, which may stop the index from being used properly.

For bigger tables, prefer a range query.

Small change.

Big difference at scale.
image

  • No matching results...
  • Searching...

/ 1000