Re: Adding keyword search (fulltext) to query

[Rick James]

To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]

How fast do each of these run?

SELECT `listings`.`id` FROM listings
WHERE `listings`.`category` = 1
AND `listings`.`city` = 35862
AND `listings`.`visible` = 1;

SELECT `descriptions_test`.`listing_id` FROM `descriptions_test`
WHERE MATCH (`descriptions_test`.`description`) AGAINST ('swimming pool' IN BOOLEAN MODE) ;

If those are reasonably fast, I am thinking about a way to get the desired ids from those two, then reach for the rest of the data.