You should use Axapta's built-in SQL trace to check which accessplan
Axapta generates to process your SQL statement.
regards,
Karsten Wollesen
Thy Data Center Development A/S
--- In [email protected], "Raal Goff"
<[EMAIL PROTECTED]> wrote:
> Im using an sql statement to run an sql query, but it seems to be
taking
> an excessively long amount of time to run. When I run the query on
the
> database directly it takes about 2mins to return the full set, but
if I
> run it through Axapta using either a statement or while select{}
loop it
> takes about 9 minutes for EACH LOOP.
>
> Is there any reason why a query would be running so long? It is
doing a
> table join against itself, (eg ledgertrans is joining against
> ledgertrans) but I wouldn't imagine that would be a terrible
problem, as
> the database server itself seems to run the query just fine, and
in less
> time. It does return quite a few results as well (something in the
order
> of 200,000 results) but ive see Axapta handle that amount of
records
> before.
>
> Anyone have any idea why a query would be taking so long to run?
>
> Cheers,
>
> --
> Raal Goff
> Software Developer
> NAS Insurance Brokers
> T 08 9480 8900
> F 08 9481 1166
> W www.nasinsurance.com.au
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.
