Bugzilla – Attachment 15967 Details for
Bug 9207
Improve z39.50 speed slowdowns for sites with many records
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 9207 - Improve z39.50 speed slowdowns for sites with many records
Bug-9207---Improve-z3950-speed-slowdowns-for-sites.patch (text/plain), 1.84 KB, created by
Marcel de Rooy
on 2013-03-08 08:47:14 UTC
(
hide
)
Description:
Bug 9207 - Improve z39.50 speed slowdowns for sites with many records
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2013-03-08 08:47:14 UTC
Size:
1.84 KB
patch
obsolete
>From dcb0409cc8d7c34256bfb533e235c26a53c9901a Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Tue, 4 Dec 2012 08:52:21 -0500 >Subject: [PATCH] Bug 9207 - Improve z39.50 speed slowdowns for sites with > many records >Content-Type: text/plain; charset="utf-8" > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > installer/data/mysql/kohastructure.sql | 3 ++- > installer/data/mysql/updatedatabase.pl | 10 ++++++++++ > 2 files changed, 12 insertions(+), 1 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index d004fe1..221c4e4 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -896,7 +896,8 @@ CREATE TABLE `import_records` ( > CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`) > REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE, > KEY `branchcode` (`branchcode`), >- KEY `batch_sequence` (`import_batch_id`, `record_sequence`) >+ KEY `batch_sequence` (`import_batch_id`, `record_sequence`), >+ KEY `batch_id_record_type` (`import_batch_id`,`record_type`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > > -- >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 041040a..ee4aeba 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -6477,6 +6477,16 @@ if ( CheckVersion($DBversion) ) { > } > > >+$DBversion = "3.11.00.XXX"; >+if ( CheckVersion($DBversion) ) { >+ $dbh->do(qq{ >+ ALTER TABLE import_records ADD INDEX batch_id_record_type ( import_batch_id, record_type ); >+ }); >+ print "Upgrade to $DBversion done (Bug 9207: Add new index batch_id_record_type to import_records)\n"; >+ SetVersion($DBversion); >+} >+ >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >-- >1.7.7.6
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 9207
:
13872
| 15967