[Koha-bugs] [Bug 6773] New: CircAutoCompl uses unlimited query

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

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: ian.walls at bywatersolutions.com
        ReportedBy: ian.walls at bywatersolutions.com
         QAContact: koha-bugs at lists.koha-community.org


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.