]> git.evergreen-ils.org Git - working/Evergreen.git/commit
projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 4a21239) | 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)
committerBill Erickson <berickxx@gmail.com>
Mon, 4 Jan 2016 15:35:35 +0000 (10:35 -0500)
commit21856cb0e88d3a135f9d282913fa64a407ef1863
tree9b2bdc339024908cc4b741f4a0b91efe13d694fbtree
parent4a21239c52478cf9e00300e51e4603504a497838commit | 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>
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 ILS