4 ms·
I second this. You can't let your queries take unusable amounts of time, but below a certain threshold relevancy is infinitely more important. I'm putting toge
by RasputinsBro 9y ago
I second this. You can't let your queries take unusable amounts of time, but below a certain threshold relevancy is infinitely more important.
I'm putting together a product which has a search feature and that uses Django + MySQL and I'm struggling with relevancy. I'd happily accept 500ms queries if that guaranteed me the relevant hit would be on the first page. That's FAR more usable than 50ms queries and then the relevant hit is on page 5.
- brightball 9y agoFull text search in MySQL isn’t in the same ballpark as PG. Thats not a dig at MySQL, just praise for the quality of what you get from the PG implementation.
- orf 9y agoWhy mysql? Search in pg is waaay better.
- pauloxnet 9y agoYes I think you need both of them of course and I found it on my project with Django and PostgreSQL.