projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 0e4c826) | 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 16:39:46 +0000 (11:39 -0500)
commit90e3d887ebeefced21e98d63b48f424b7ee5703f
tree9b2bdc339024908cc4b741f4a0b91efe13d694fbtree
parent0e4c8262d1dfec7d92af36d75acdf4db5612aee5commit | 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