Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Very slow query causing 400% slow down of results #97

Closed
jonathan-bird opened this issue Mar 26, 2019 · 1 comment
Closed

Very slow query causing 400% slow down of results #97

jonathan-bird opened this issue Mar 26, 2019 · 1 comment

Comments

@jonathan-bird
Copy link

There is a bit of code here that's very slow due to the fact you're calling get column listing which takes approx 300ms just to get that result: https://github.com/TomLingham/Laravel-Searchy/blob/master/src/SearchDrivers/BaseSearchDriver.php#L123

The query without this I can get down to <50ms but with this, you're slowing it down to almost 400ms on average, which on a big loop, is very expensive in terms of speed.

I'd personally suggest just removing this or having an option to not run the query. In my branch I've just removed it as I don't need it.

@TomLingham
Copy link
Owner

Please see #117

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants