LP1464765: Speed Up Number Padding for Sort Keys
authorJason Boyer <jboyer@library.in.gov>
Tue, 30 Jun 2015 12:53:21 +0000 (08:53 -0400)
committerGalen Charlton <gmc@esilibrary.com>
Thu, 5 Nov 2015 15:38:42 +0000 (15:38 +0000)
commit59c773e00d7c94984918004c5efd6f08011ab239
tree5ba34e9cb731f8f113ba9d051cd11a66100a3f98
parent01c32c5c1c7fc3a5e99b7c5fb50129ca051886d5
LP1464765: Speed Up Number Padding for Sort Keys

[New commit message by Galen Charlton:]
This patch was originally written to fix a problem with
normalization of various labels, but the patches for
bug 1155313 fixed the function problem.  However, testing
shows that this version of evergreen.lpad_number_substrings()
is about a third faster, so this patch is being merged to
get the speed improvement and the additional tests.

Thanks to Thomas Berezansky for a much simplified approach.

Signed-off-by: Jason Boyer <jboyer@library.in.gov>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Open-ILS/src/sql/Pg/002.functions.config.sql
Open-ILS/src/sql/Pg/t/lpad_number_substrings.pg
Open-ILS/src/sql/Pg/upgrade/XXXX.function.lpad_number_fix.sql [new file with mode: 0644]