LS

Having some differnces in query time between EDBMngr and my testapp. Should
the code below give an accurate result or...

var
 T1, T2 : TTime;
 with EDBQuery do begin
   Close;
   RequestSensitive := cbLive.Checked;
   RequestPlan := TRUE;
   SQL.Text := memoSQL.Text;
   DisableControls;
   T1 := Now;
   Open;
   T2 := Now;
   EnableControls;
   memoPlan.Lines.AddStrings(Plan);
   lblSeconden.Caption := FormatDateTime('ss:zzz', T2 - T1 );
   lblRecords.Caption := IntToStr(RecordCount);
 end;

Regards, Harry

It seems that there only is a differnece when I measur a query with
requestlive set to TRUE. Is this measured differently in EDBmngr?

Harry

"Harry de Boer" <harry@staaf.nl> schreef in bericht
news:97EA4DE4-46A2-4017-B6E3-1ABE7C214E92@news.elevatesoft.com...
> LS
>
> Having some differnces in query time between EDBMngr and my testapp.
Should
> the code below give an accurate result or...
>
> var
>   T1, T2 : TTime;
>   with EDBQuery do begin
>     Close;
>     RequestSensitive := cbLive.Checked;
>     RequestPlan := TRUE;
>     SQL.Text := memoSQL.Text;
>     DisableControls;
>     T1 := Now;
>     Open;
>     T2 := Now;
>     EnableControls;
>     memoPlan.Lines.AddStrings(Plan);
>     lblSeconden.Caption := FormatDateTime('ss:zzz', T2 - T1 );
>     lblRecords.Caption := IntToStr(RecordCount);
>   end;
>
> Regards, Harry
>
>

Harry,

<< It seems that there only is a differnece when I measur a query with
requestlive set to TRUE. Is this measured differently in EDBmngr? >>

EDB doesn't include the open/row navigation time at the TDataSet layer,
which with sensitive queries will be the bulk of the time, and was the bulk
of the time in your issue that you're seeing with selecting one row.  It
only includes the the actual time spent to execute the query in the engine,
which is usually 0-0.30 seconds for sensitive query result sets.

--
Tim Young
Elevate Software
www.elevatesoft.com