Re: Client/Server query strategy
From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 15 Mar 1995 13:18:33 GMT
Message-ID: <3k6pf9$fsu_at_ixnews3.ix.netcom.com>
Date: 15 Mar 1995 13:18:33 GMT
Message-ID: <3k6pf9$fsu_at_ixnews3.ix.netcom.com>
In <3k1ir8$qej_at_ef2007.efhd.ford.com> wmeahan_at_ef0424.efhd.ford.com (Bill Meahan) writes:
>>Is it possible to keep the transaction open until the aggregate table
>>is updated too? (I'm not real familiar with how Oracle trigger's work.
>
>Yes, but if it takes 3 minutes to calculate the sum of a column on a
multi-million-row
>table, do you _really_ want to make the updater waith that long?
(Maybe you do,
>as they say, "your mileage may vary.")
Maybe I'm missing something here, but if you initially create the table using the sum() function, you shouldn't need to recalculate against the entire detail table again. Just add and subtract individual transactions.
Chuck Received on Wed Mar 15 1995 - 14:18:33 CET