Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Query time |
Fri, Jun 1 2007 9:40 AM | Permanent Link |
"Harry de Boer" | 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 |
Fri, Jun 1 2007 9:49 AM | Permanent Link |
"Harry de Boer" | 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 > > |
Fri, Jun 1 2007 3:27 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |