issue #7155 - fre is slow. first pass at using temp table to (1) reduce the amount...
authorGil Moskowitz <gilmoskowitz@acm.org>
Mon, 9 Jun 2014 22:20:01 +0000 (18:20 -0400)
committerGil Moskowitz <gilmoskowitz@acm.org>
Mon, 9 Jun 2014 22:20:01 +0000 (18:20 -0400)
commite5e4e2355d74cb4bd2d3f54913f89d19851fdb0a
tree53ed57520cd81d522d69fe9b2cc4713eeeb3330a
parent30bc846fc0ff6ac4fec24c2c50737a18a0f802d4
issue #7155 - fre is slow. first pass at using temp table to (1) reduce the amount of data to wade through and (2) reduce the complexity of the filtering criteria. initial testing shows runtime reduction in a simple db from 20-30 sec down to 2-9 sec for a set of reports; add a simple test, too.
foundation-database/public/functions/financialreport.sql
foundation-database/public/functions/insertflgroup.sql
test/database/financialreport.js [new file with mode: 0644]