Wikia/interactive-maps — pull request #232 by nandy-andy (2014-10-09 17:05:28+00:00)
Title: MWEB-700 Use LIKE in SQL query to find map templates

Because of performance reasons we used a separate table in MySQL with `InnoDB` engine to use full text search feature. Unfortunately from the user-side perspective MySQL fulltext search didn't work out because of its limitations: users weren't able to find "California" template if they had typed "Cal" into search input.

We discussed it with OPS team and using LIKE is safe here for now. We'll be monitoring rows in `tile_set` table and once it gets close to 50k rows we'll have to change the solution to a different one.

Changes below simply remove fulltext search and add "LIKE search".