As far as I can see you don't reset st before the execution of the
query, so it prints the time for both the while select and the query
initialization and the query execution. Or am I missing something
here?
I guess you should also do a queryrun.get(tablenum(xxx)) into a
buffer in the queryloop to get the same functional result as the two
select loops (where the programmer has a initialized buffer
available).
Can you post the result from a run with that fixed, I would like to
see the real result (since I believe that the query - from the time
it's executed) and a select should be more or less equally fast.
Kind regards,
Rolf Olsen
thy:development
--- In [email protected], "Bayliss, Barry"
<[EMAIL PROTECTED]> wrote:
>
>
> Hello Steeve,
>
> Can you post the code you used to test, as I found the following:
>
>
> Using the next method: 2:27.002
> Using the while method: 2:27.010
> Using the query method: 5:04.052
>
> The number of records in the table was: 59071
>
> The code I used was:
>
> static void Job231(Args _args)
> {
> Query Query;
> QueryBuildDataSource qbds;
> QueryRun QueryRun;
> PCDrockfastTrxHeader PCDrockfastTrxHeader;
> int i,st;
> ;
>
> // Ensuring the creation of an execution plan
> while
> select PCDRockfastTrxHeader
> {
> i = 0;
> }
>
> st = winAPI::getTickCount();
> select PCDrockfastTrxHeader;
> while (PCDrockfastTrxHeader)
> {
> i = 0;
> next PCdrockfastTrxHeader;
> }
> info("Next: " + Milliseconds2strhms(winAPI::getTickCount() -
st));
>
> st = winAPI::getTickCount();
> while
> select PCDrockfastTrxHeader
> {
> i = 0;
> }
> info("While: " + Milliseconds2strhms(winAPI::getTickCount() -
st));
>
>
> Query = new Query();
> qbds = Query.addDataSource(TableNum
(PCDRockfastTrxHeader));
> QueryRun = new QueryRun(Query);
>
> while (QueryRun.next()) {
> i = 0;
> }
> info("Query: " + Milliseconds2strhms(winAPI::getTickCount() -
st));
> }
>
> The following was placed in the global class.
>
> static TempStr milliSeconds2StrHMS(int time)
> {
> int millisec;
> ;
>
> millisec = time mod 3600 mod 60 mod 1000;
> time = time div 1000;
> return Time2strHMS(time) + "." + num2str0(millisec, 3,0,0,0);
> }
>
>
>
>
> Barry.
>
>
>
>
> -----Original Message-----
> From: [email protected] [mailto:development-
[EMAIL PROTECTED] On Behalf Of Steeve Gilbert
> Sent: Thursday, 22 December 2005 12:03 AM
> To: [email protected]
> Subject: RE : RE : [development-axapta] Reset position in a
tablebuffer
>
> Sorry, I always tought "while select" was faster but just did a
test and it doesn't seem so.
>
> Steeve...
>
>
> -----Message d'origine-----
> De : [email protected] [mailto:development-
[EMAIL PROTECTED] De la part de densop1
> Envoyé : 21 décembre 2005 04:01
> À : [email protected]
> Objet : Re: RE : [development-axapta] Reset position in a
tablebuffer
>
> Yes "select ct" initialises the buffer again. But it doesn't matter
> if you uses "while select" or "next".
>
> Simon
>
> --- In [email protected], "Steeve Gilbert"
> <[EMAIL PROTECTED]> wrote:
> >
> > I would redo the "select ct;". But you should be doing that
> instead :
> >
> > While select ct {
> > info(ct.AccountNum);
> > }
> >
> > Steeve...
> >
> >
> > -----Message d'origine-----
> > De : [email protected] [mailto:development-
> [EMAIL PROTECTED] De la part de cdlmalherbe01
> > Envoyé : 20 décembre 2005 06:02
> > À : [email protected]
> > Objet : [development-axapta] Reset position in a tablebuffer
> >
> > Hi all,
> >
> > An obvious question to the more experienced, but how does one
> reset
> > the cursor's position to the first record in a tablebuffer?
> >
> > Example
> > ========
> >
> > CustTable ct;
> >
> > ;
> >
> > select ct;
> >
> > while (ct)
> > {
> > info(ct.AccountNum);
> >
> > next ct;
> > }
> >
> > /*what call goes here to reset position of the cursor to the
first
> > record in the table buffer?*/
> >
> > while (ct)
> > {
> > info(ct.Name);
> >
> > next ct;
> > }
> >
> > Kind regards,
> >
> > Christoph
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
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.
