Re: 回复：[GENERAL]SP to calc shipments vs receipts

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