| From: | Bret Stern <bret_stern(at)machinemanagement(dot)com> |
|---|---|
| To: | Chris Travers <chris(dot)travers(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 回复：[GENERAL] SP to calc shipments vs receipts |
| Date: | 2013-09-25 15:03:41 |
| Message-ID: | 1380121421.2723.24.camel@centos-dev.machinemanagement.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2013-09-25 at 07:46 -0700, Chris Travers wrote:
>
>
>
> On Wed, Sep 25, 2013 at 7:27 AM, DDT <410845160(at)qq(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lonni J Friedman | 2013-09-25 15:15:27 | postgres FDW doesn't support sequences? |
| Previous Message | DDT | 2013-09-25 14:56:09 | Re: [GENERAL] 回复：[GENERAL] SP to calc shipments vs receipts |