Performance - DomianFunction vs SubQuery

[mordja]

Hi,

Im am wondering what is best in terms of performance out of using a sub query or a domain sum. In a query I need to calculate an adjustment which is based on the sum of another table. Is it better to use a sub query which calculates the sum and use that in my expression than a dsum. Even though the dsum returns the same value throughout it will still run once for each row. Any suggestions ?

MOrdja

 

[JonFer]

Subqueries are usually faster than a domain aggregate function. Add indexes if you haven't already and it is a correlated subquery.


John

http://www.interautomateconsulting.com