Tag: full-text-search

Meilisearch: user protected search

I have a database table “movies” with three fields: id, title and user_id. Behind a login users can create new movies with a custom title. The user_id is set automatically to the current logged in user. Now on another page (also behind the same login) the users can see all their own created movies as a list. They also can

Manticore – sphinxQL GROUP BY duplicated grouped id

full-text-search manticore php sphinx sphinxql

When I using GROUP BY syntax in Manticore, there are results with duplicated grouped id. We’ve just migrated from sphinx 2.X to the latest Manticore, and in Sphinx there wasn’t this promlem with the …

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 –