projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: d9b54f3) | patch
Lp1883171&1940663: Replace latest inventory view with rollup table
authorJason Stephenson <jason@sigio.com>
Sun, 14 Nov 2021 18:47:37 +0000 (13:47 -0500)
committerJason Stephenson <jason@sigio.com>
Sun, 14 Nov 2021 20:57:47 +0000 (15:57 -0500)
commit21581210e023cd399ed54d0117b3c7b29bb0960c
tree6725a387a6c4b3a8d667ca64b6004ae90f777ab1tree
parentd9b54f3699b7113a7e2de468af6e9bbed782518ecommit | diff
Lp1883171&1940663: Replace latest inventory view with rollup table

Use a rollup table, what our community calls a materialized view, for
the asset.latest_inventory data.  This should be faster in large data
environmnets than a traditional view.

Signed-off-by: Jason Stephenson <jason@sigio.com>
Open-ILS/src/sql/Pg/040.schema.asset.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.actor.copy_inventory.sql diff | blob | history
Evergreen ILS