[Koha-bugs] [Bug 15104] Batch Record Modification Performance Improvement

[bugzilla-daemon at bugs.koha-community.org]

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.