Try activating SQL trace (Tools/options/SQL/SQL Trace) - output to
infolog. Then you can see how the join actually are performed.
regards,
Karsten Wollesen Clausen
Thy Data Center Development A/S
--- 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.
