http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8309

--- Comment #3 from Paul Poulain <[email protected]> ---
Created attachment 10475
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10475&action=edit
Borrowers table management

first draft, the interesting part is the testrelation.pl script that shows how
to search a patron and access other informations from here

What is important is the "prefetch" option in read. With it you'll LEFT join
the prefetched table, thus improving performances

You can also notice the cache duration of 2 seconds in borrower search. The
idea is that, if this sub is called more than once on a given page, there will
be only one SQL query.

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
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/

Reply via email to