https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1707
Jonathan Druart <jonathan.dru...@bugs.koha-community.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jonathan.dru...@bugs.koha-c
| |ommunity.org
--- Comment #4 from Jonathan Druart <jonathan.dru...@bugs.koha-community.org>
---
(In reply to Petter Goksøyr Åsen from comment #3)
> 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
How d(In reply to Petter Goksøyr Åsen from comment #3)
> 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
For the records: http://irc.koha-community.org/koha/2016-10-13#i_1866950
Petter, how did you finally fix it?
I have several ways to fix it but I don't figure out which one is the best.
--
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/
