Skip to content

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…

Slow MySQL full text search

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 – que…