https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1707

Petter Goksøyr Åsen <boutrosboutrosbout...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |boutrosboutrosboutros@gmail
                   |                            |.com

--- Comment #3 from Petter Goksøyr Åsen <boutrosboutrosbout...@gmail.com> ---
This is still a problem. I'd say the member search is dangerous and generates
some horrible queries which takes many minutes to run if you have a large
dataset.

We have over 300,000 patrons.

If someone search for something stupid like %29% - this is (part of) the
generated query:
https://gist.githubusercontent.com/boutros/db14414591ea77638b2a3a183a18ec00/raw/d59f7ef33890b7a034f24a0d350b5af3b6257e4e/bigquery.sql

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to