Bug 6078: Request to find borrowers without issues overload the server
authorSophie Meynieux <sophie.meynieux@biblibre.com>
Mon, 28 Feb 2011 15:25:23 +0000 (16:25 +0100)
committerChris Nighswonger <chris.nighswonger@gmail.com>
Wed, 10 Aug 2011 21:48:49 +0000 (17:48 -0400)
commit9e03bb0edcc2e7f6a851c35af2c70bdf9573e228
tree80d2b0bc20cb3d97f958fbab8339b785852575ed
parent36523ea36a1bee67c09c16305ff4ec4a719082b8
Bug 6078: Request to find borrowers without issues overload the server

Optimization of the SQL request using NOT EXISTS instead of NOT IN

BibLibre MT5946

Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz>
Signed-off-by: Paul Poulain <paul.poulain@biblibre.com>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
(cherry picked from commit e1370001c65ca75d44497896fe6f47c716a62f26)

Signed-off-by: Chris Nighswonger <chris.nighswonger@gmail.com>
reports/borrowers_out.pl