Timeline for MySQL fulltext query is very slow | What I'm doing wrong?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 24, 2020 at 22:31 | comment | added | sdeav | Did that, still 2500 ms. | |
| Aug 24, 2020 at 22:22 | comment | added | nbk | add an index on city_id | |
| Aug 24, 2020 at 22:20 | comment | added | sdeav | Latest available version. And I remember that I have searched even with 0,5 million rows with this hardware. But, I forgot how I did that.. | |
| Aug 24, 2020 at 22:01 | comment | added | nbk | then you should try faster hardware also yu didn't wrote which mysql version you are using | |
| Aug 24, 2020 at 21:47 | comment | added | sdeav | My rows will be maximum 0,5 million. I don't think I should mess up with elasticsearch for that. But still, 1500 is not fast enough for 100,000 rows... | |
| Aug 24, 2020 at 21:43 | comment | added | nbk | 1,5 seconds is quote fast and as you can see here makandracards.com/makandra/… the performance isn#t good with big databases. if you really want ti get quicker and don't fear soe work look for elasticsearch. | |
| Aug 24, 2020 at 21:30 | comment | added | sdeav | Thank you. But now it takes 1500 ms. Which is still too slow. | |
| Aug 24, 2020 at 21:19 | history | answered | nbk | CC BY-SA 4.0 |