[Koha-bugs] [Bug 30645] Generated DBIC query incorrect for API searches across joined extended attributes when several terms are passed

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #24 from Pedro Amorim <pedro.amorim at ptfs-europe.com> ---
(In reply to Jonathan Druart from comment #22)
> I guess performances (see bug 33554) will be even worst with this change :-/

I've done some testing myself and cannot find evidence of this.

Clean k-t-d (before applying patches):
1) Visit patrons home:
http://localhost:8081/cgi-bin/koha/members/members-home.pl
2) Open network tools and click "Search"
3) Do this several times (like 10), take note of the average time it takes for
the request to come back (for me, averaging around 185-195ms)
4) Run the following command (!!DEV KTD ONLY!!):
bash <(curl -s
https://raw.githubusercontent.com/ammopt/koha-ill-dev/master/scripts/dev-data-pattributes.sh)
30000
5) If all goes well, the above command will add 30.000 patrons, 300 searchable
borrower_attribute_types and 30.000 borrower_attributes. It may take a few
minutes to finish, but required to test performance.
6) After 5) is done. Repeat 3) Notice it now takes a while longer (for me, its
now averaging aroudn 225ms)
7) Apply patches from 30645, restart plack and flush_memcached
8) Notice if there's any difference, for me, I'm averaging about the same 225ms
as before.
9) Do more testing, search for searchable fields specifically, having tried
that myself I don't see any impact.

-- 
You are receiving this mail because:
You are watching all bug changes.