You can surely save on the number of calls being made to the database by
joining the two tables in the while select instead of separate calls to the
database for the while select followed by another select. If you do not use the
index hint the database will choose an optimum index, provided
: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Varden Morris
Sent: 01 November 2007 11:02
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] select firstonly
You can surely save on the number of calls being made to the database
: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
[mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: 01 November 2007 11:02
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly
You can surely save on the number
Varden
James
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Varden Morris
Sent: 01 November 2007 11:37
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] select firstonly
You are most welcome. I
, 2007 8:37 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] select firstonly
You are most welcome. I have done countless tuning with joins as oppose to
individual selects and see major improvement in performance when the dataset is
large. Another thing you
]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, November 1, 2007 9:49:52 AM
Subject: RE: [Axapta-Knowledge-Village] select firstonly
Thanks a lot Varden,
I have not done much 'tunning' so thinking and trying various bits out so
your advice is great and will save me a lot of time in trial
From: Harry Deshpande [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, November 1, 2007 10:15:56 AM
Subject: RE: [Axapta-Knowledge-Village] select firstonly
Hi
May be worthwhile to ' join tableid from inventTable
:[EMAIL PROTECTED] On
Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 9:27 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] select firstonly
Hey Harry,
This sounds new and unclear to me. Can you please give me some more details on
what you
-Village@yahoogroups.com
Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, November 1, 2007 10:29:52 AM
Subject: RE: [Axapta-Knowledge-Village] select firstonly
Hi
If recid is not part of the index then the logic has to do one more lookup to
get the recid. With tableId you get rid
-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] select firstonly
Ok, I think I may understand what you are saying. Are you refering to a cover
index where the database uses the fields in the index page as the data without
using the data page (provided that all the required data
-Village@yahoogroups.com
Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, November 1, 2007 10:29:52 AM
Subject: RE: [Axapta-Knowledge-Village] select firstonly
Hi
If recid is not part of the index then the logic has to do one more lookup to
get the recid. With tableId you get rid
11 matches
Mail list logo