[Koha-patches] [PATCH] BUG-2393: ENHANCEMENT: SearchMember() uses "cardnumber%" wildcard - if other search-types fail
paul POULAIN
paul.poulain at biblibre.com
Fri Jul 25 08:57:07 CEST 2008
Mason James a écrit :
> Some good points raised here, especially Joe's point re: performance
>
> So, its good for Koha to attempt to return some results - if no
> results are returned...
> But there needs to be a LIMIT (10 or 100?) on those results, so staff
> dont accidentlly cause runaway SQL queries.
>
Please note that the SQL "LIMIT" pragma is mySQL specific. So it must be
avoided.
my 2cts
--
Paul POULAIN
http://www.biblibre.com
Expert en Logiciels Libres pour l'info-doc
NOUVEAU TELEPHONE : 04 91 81 35 08
More information about the Koha-patches
mailing list