search

nqxcode / laravel-lucene-search

Laravel 4.2, 5.* package for full-text search over Eloquent models based on ZF2 Lucene.
73 stars 28 forks source link

Working very slow with mysql #52

Closed msafayasar closed 6 years ago

msafayasar commented 7 years ago

I have a table with about 40.000 rows and searching only one column. And for every search it takes about 25seconds. I am using Lucene to find names similar to the input and get them with AJAX. When I look at the timing, I see that every request takes nearly 25seconds as TTFB and even after I increased memory of my server, the speed did not change. The question is "How can I increase the search speed?"

nqxcode commented 6 years ago

Too many unknowns to solve such a problem.