This query runs on every request and the first % is not needed thus it's a slow query because the index cannot be used in that case. This makes the query run about 20 times faster on a big table
Applying this patch on my website improved the TTFB by 500ms which is huge
This query runs on every request and the first % is not needed thus it's a slow query because the index cannot be used in that case. This makes the query run about 20 times faster on a big table
Applying this patch on my website improved the TTFB by 500ms which is huge