How to show the elapsed time while a long SQL Query is executed?
Posted
by Salvador
on Stack Overflow
See other posts from Stack Overflow
or by Salvador
Published on 2010-03-26T21:11:17Z
Indexed on
2010/03/27
11:33 UTC
Read the original article
Hit count: 315
i need to show a popup window before the a query execution, show the time elapsed while the sql query is executed , and close that windows when the query ends.
actually i do something like this
var
frm : tFrmPopupElapsed;
// this form have a ttimer and a tlabel to show the elapsed time
//but the tlabel is not updated, i tried using update; and refresh; but nothing happens
//the timer is enabled.
begin
frm:=tform.create(nil);
frm.Init;//this procedure set the timer to enabled:=true
try
frm.Show();
ExecuteMyVeryLongQuery();
finally
frm.Close;
end;
end;
wich is the best way using a ttimer? a Tthread ?
thanks in advance.
© Stack Overflow or respective owner