[Koha-patches] [PATCH 56/78] pending reserves, improve perfs (not related to new_acq)

[Joe Atzberger]

> -AND items.itemnumber NOT IN (SELECT itemnumber FROM issues)
> +AND issues.itemnumber IS NULL
>

Now that's an important change!  It keeps the subquery from crippling the
system hitting every row in the issues table.

-- 
Joe Atzberger
LibLime - Open Source Library Solutions
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-patches/attachments/20090616/3acfa72a/attachment-0002.htm>