Tag: full-text-indexing

Optimize MySQL FULL TEXT search

full-text-indexing full-text-search mysql php sql

I have a search with only one field that allows me to search in several columns of a MySQL table. This is the SQL query: SELECT td__user.* FROM td__user LEFT JOIN td__user_oauth ON td__user.id = …

Slow MySQL full text search

full-text-indexing full-text-search mysql php

I’m using this query to perform a full text search on a MySQL database: The results are very relevant, but the search is really slow and is getting slower and slower as the tables grow. Table stats: questions – 400 records indexes PRIMARY BTREE – id BTREE – uniquecode BTREE – questiondate BTREE – userid FULLTEXT – questiontext FULLTEXT –