[Koha-bugs] [Bug 15104] Batch Record Modification Performance Improvement
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Nov 5 02:30:44 CET 2015
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15104
--- Comment #2 from cnorthcott.work at gmail.com ---
Created attachment 44446
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=44446&action=edit
Bug 15104: Batch Record Modification Performance Improvement
Performance improvements to speed of the Modify Records by decreasing
unnecessary
progress reporting of success messages and data fetching while logging.
Test Plan:
1) Prepare NTYprof
(http://wiki.koha-community.org/wiki/Profiling_with_Devel::NYTProf)
or procure a stopwatch (stopwatch will be simpler but less accurate).
2) Ensure you have a decent number of records in your Koha system (>500) if you
are
lacking records to modify in your database you can import some from files
found here: http://wiki.koha-community.org/wiki/Free_sample_MARC_data
3) Prepare a file with biblionumbers to modify. You can create a file
containing
all record called ItemBarcodes.txt in the current folder using the
following command from the machine running Koha:
echo 'select biblionumber from biblio' | sudo koha-mysql kohadev >>
BiblioNums.txt
4) Navigate to Home > Tools > MARC modification templates in the Koha Intranet.
5) Create a new template called ModRec1.
6) Add a new action using:
Select 'Add/Update' from the drop down box and in the field(s) boxes enter
'090'
(in the first box) and 'a' (in the second box) and 'Mod1' in the value
field.
Then click 'Add Action'
7) Create a new template called ModRec2.
8) Add a new action using:
Select 'Add/Update' from the drop down box and in the field(s) boxes enter
'090'
(in the first box) and 'a' (in the second box) and 'Mod2' in the value
field.
Then click 'Add Action'
9) Navigate to Home > Tools > Batch Modify Records in the Koha Intranet
10) Click the 'Browse...' button and select BiblioNums.txt or your equilient.
11) Select ModRec1 under Use MARC Modification Template.
12) Click the 'Continue' button and scroll to the bottom of the page.
13) If you are using a stopwatch, prepare your stopwatch so that you will
start counting seconds from the point you click the button in the next
step.
14) Click the 'Modify Selected Records' button (simultaneously start your
stopwatch if using one)
15) When the page appears showing completion of the change, stop your stopwatch
and check the time or navigate to the folder you have set NYTProf to
output.
16) Record the runtime. This is the pre-optimisation time.
17) If this is the pre-patch test then you should see lots of messages like:
"The biblio #### has successfully been modified."
If this is the post-patch test then you should see only:
"All records have successfully been modified!"
and a link to do another record modification.
18) Apply this patch.
19) Repeat steps 9-12 of this testplan with the patch applied, replacing
ModRec1
in step 11 with ModRec2. This will yield the post-optimisation time. If you
are using NYTProf you will need to apply the -d:NYTProf shebang to the file
again.
20) Compare the pre-optimisation time and post optimisation time. The second
post-optimisation time should be faster.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list