Bugzilla – Attachment 13872 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.85 KB, created by
Kyle M Hall (khall)
on 2012-12-04 13:51:36 UTC
(
hide
)
Description:
Bug 9207 - Improve z39.50 speed slowdowns for sites with many records
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2012-12-04 13:51:36 UTC
Size:
1.85 KB
patch
obsolete
>From 274368d82595b8dbc5562068e80c0610ce0bdb35 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 > >--- > 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 a814eab..590a7df 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 a6af263..ed37515 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -6114,6 +6114,16 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { > SetVersion($DBversion); > } > >+$DBversion = "3.11.00.XXX"; >+if ( C4::Context->preference("Version") < TransformToNum($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.2.5
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