of cause the display method is executed every time you select the
record. To improve performance, you could use a list to store once
calculated values and return only the calculated value in the
display method.
Otherwise you do a sum over the two joined tables for every
record ...
karsten
--- In [EMAIL PROTECTED], "agramm2000"
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a new display field in form PurchQuickQuote which needs to
be
> computed quickly a join of 2 tables with aggregate sum
> select sum(..)
> ...
> join table 2
> ....
>
> But if I do so I get bad performance for standard executequery on
> datasource inventtable.
>
> What could be the reason.
>
> I'm working with 3tier thin on Ax25 SP3.
>
> Any Ideas are welcome.
>
> Thanx
> Andi
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
