On Wed, 2013-09-25 at 07:46 -0700, Chris Travers wrote:
>
>
>
> On Wed, Sep 25, 2013 at 7:27 AM, DDT <410845160@qq.com> wrote:
> By the way, you can try to save the current totals to another
> table.
> update it through triggers when the inventory transactions
> changed.
> it may lead to better performance on a large set of inventory
> transactions for query current totals
>
>
> If you are going to do this, my recommendation is to store periodic
> summaries (i.e. for sum through date) and then aggregate rolling
> forward. This vastly simplifies querying and data validation if you
> are only appending data.
> --
> Best Wishes,
> Chris Travers
>
>
> Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
> lock-in.
> http://www.efficito.com/learn_more.shtml
Thanks Chris for the suggestions.
With all the input from this forum, my project is looking pretty sweet.
B Stern