From f45f85a227b3fc53eef3d8557205181a3ce74ad4 Mon Sep 17 00:00:00 2001 From: Paul POULAIN Date: Fri, 2 May 2008 19:03:23 +0200 Subject: [PATCH] ordering by biblioitemnumber for best performance Signed-off-by: Joshua Ferraro --- misc/batchupdateISBNs.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/misc/batchupdateISBNs.pl b/misc/batchupdateISBNs.pl index a613b95b7a..2752aabc3d 100755 --- a/misc/batchupdateISBNs.pl +++ b/misc/batchupdateISBNs.pl @@ -63,7 +63,7 @@ my $cpt_isbn = 0; if(not $no_isbn){ my $query_isbn = " - SELECT biblioitemnumber,isbn FROM biblioitems WHERE isbn IS NOT NULL + SELECT biblioitemnumber,isbn FROM biblioitems WHERE isbn IS NOT NULL ORDER BY biblioitemnumber "; my $update_isbn = " @@ -94,7 +94,7 @@ if(not $no_isbn){ if(not $no_marcxml){ my $query_marcxml = " - SELECT biblioitemnumber,marcxml FROM biblioitems WHERE isbn IS NOT NULL + SELECT biblioitemnumber,marcxml FROM biblioitems WHERE isbn IS NOT NULL ORDER BY biblioitemnumber "; -- 2.20.1