u can try to use Indexing or put more condition in your query
"Bayliss, Barry" <[EMAIL PROTECTED]> wrote:
Hello Raal,
If this is still a problem, please send me a copy of the code concerned.
Barry.
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Raal Goff
Sent: Thursday, 23 June 2005 4:20 PM
To: [email protected]
Subject: [development-axapta] Long Query time
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
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "development-axapta" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
SMILE
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
