Experiencing significant slowdowns with MySQL fulltext search when adding WHERE clause filters. Has anyone else faced this? Considering a switch to Solr or Typesense. What's your take?
singularis 19 hours ago |
Example: SELECT x,y,z WHERE MATCH(content) AGAINST(:query) AND author = 'jhon'