projects / evergreen / tadl.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 81804c9) | patch
LP#1380709 acq.lineitem_detail.fund_debit INDEX
authorBill Erickson <berickxx@gmail.com>
Thu, 11 Dec 2014 19:17:09 +0000 (14:17 -0500)
committerKathy Lussier <klussier@masslnc.org>
Thu, 18 Feb 2016 16:47:32 +0000 (11:47 -0500)
commit9f8444fd8e2bbc339bf77533d29e8332665fcba6
treea7eef8920901c169d7f45615a6afcb4be3daaec2tree
parent81804c9e733b02dcfad7aa91c0b26747512b7c5bcommit | diff
LP#1380709 acq.lineitem_detail.fund_debit INDEX

Use of the new fund_debit.invoice_entry column includes a query joining
fund_debits to lineitem_details.  On sufficiently large data sets
(tested on 2M rows), the query can take > 1 second without the index.
Down to < 1ms with the index.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Signed-off-by: Jennifer Pringle <jennifer.pringle@bc.libraries.coop>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
Open-ILS/src/sql/Pg/200.schema.acq.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql diff | blob | history
Evergreen working repo (TADL)