http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6773
Bug #: 6773
Summary: CircAutoCompl uses unlimited query
Classification: Unclassified
Change sponsored?: ---
Product: Koha
Version: rel_3_6
Platform: All
OS/Version: All
Status: NEW
Severity: minor
Priority: P5
Component: Architecture, internals, and plumbing
AssignedTo: [email protected]
ReportedBy: [email protected]
QAContact: [email protected]
The SQL in circ/ysearch.pl is unlimited as to the number of results it returns,
and since it's called for each character typed into the patron search
interface, databases with many patrons (100,000+) can experience resource
drain. Further, since the interface only returns 10 results at a time, the
bulk of the work done by the query goes to waste.
The SQL in circ/ysearch.pl should limit to 10 results only, and the system
preference text in the staff client should note this limitation, for the
administrator's knowledge.
--
Configure bugmail:
http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.
_______________________________________________
Koha-bugs mailing list
[email protected]
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/
