Database Performance Opportunity

[larsborn]

We are sending quite some queries like

(SELECT id FROM tbl_sample_sources WHERE source like '%somethingsomething%' LIMIT 1000)

to the database. Using wildcards both in the beginning and the end is hard to optimize for MySQL.

[silascutler]

Yeah, I'll start looking into ways to improve this. When it was initially written I wanted to ensure support for searching for parts of the URI path - Ex:

[larsborn]

I think a FULLTEXT index would be the way to go then. If you like, I can take care of this in a few weeks!

[silascutler]

Sounds good. I'll leave it to you