]> git.koha-community.org Git - koha.git/commit
Bug 13669: (alternative) use DBIx::RunSQL
authorBernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Wed, 18 May 2016 19:25:25 +0000 (16:25 -0300)
committerJulian Maurice <julian.maurice@biblibre.com>
Wed, 25 May 2016 08:05:11 +0000 (10:05 +0200)
commite8a703b076fde26dd626711bae5a459bfdf16bb1
tree9936b66a81ce14a4c8e73b8498472a4fdfac1fcb
parent24373a1745cb8ba7e6cf0aec24bdd4f958944b54
Bug 13669: (alternative) use DBIx::RunSQL

Alternative POC solution, on top of
previous patches, feel free to obsolte.

This patch use DBIx::RunSQL->run_sql_file
to procees each sql file.

To test:
1) Apply all patches
2) Same test plan of patch 1

Timing test running web installer, marc21,
all sample data, time in seconds

a) without patch
structure   data
59.7        66.5
58.6        66.0

b) SQL::SplitStatement (patch 1+2)
59.4        101
59.7        102

c) DBIx::RunSQL (patch 3)
60.7        66.8
59.4        66.2

Tomas' version is a bit slower loading sample data,
all give similar results processing kohastructure.

New dependency to package: DBIx::RunSQL

Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
(cherry picked from commit e64f01ce0d6b3ff127a23070aa82427b69d89263)
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
C4/Installer.pm
installer/data/mysql/en/optional/marc21_holdings_coded_values.sql