Do you have an index on the table that could make it quicker to select the records for the sum? So, for example, if you are getting a total on Sales by SalesStatus, using the SalesLine table, then there is an index (already setup) called "StatusItemIdx" that could speed up the processing.
So you may need to create an index on your table that can speed up the select process for the sum. --- In Axapta-Knowledge-Village@yahoogroups.com, Donny Wu <doni...@...> wrote: > > Hi Guys, > > Got a strange case, when I try to select sum(field1) from Invensettlement it > takes about 3 - 4 minutes but if I try to run the query directly to SQL > Analyzer, it's only needs about 30 seconds. > > Anyone have any idea how to solve this performance issue ? > > rgds, > > dwu >
