Progress of SQL Query

[dropper]

Hello guys and gals,

Firstly just want to thank to for a great forumn...Learnt most of Delphi here

Ok, I have a query running on a dataset in Delphi 5. Depending on the size of the dataset the query takes some time to execute.

I would like to know if there is some way to give the user an indication of the progress of the query or just something to confirm that the software is running...

Thanks
Alvin

 

[LucieLastic]

hi

I don't think there is a way. If there is, though, I'd also be interested to know about it.

Firstly, though, maybe we can help you with your query, do you want to post it on here and we'll have a look to see if it can be optimised.

lou

 

[michaenh]

Hi

Maybe you could create a progressbar or TAnimate figures(hour glass) before you execute the query and destroy it after the query have been executed..

this is something to confirm that the software is running..

cheers,
mha

 

[towerbase]

Obviously any progress report is going to depend on whether the DBMS you are using provides this facility.

You can get a progress report on a TQuery if you are using the (much maligned) BDE by the use of call back functions which give a percentage complete figure.

I have used this in the past but the problem is that the DBMS doesn't really know how long a query is going to take (query complexity, network traffic, disk activity and so on). If memory serves me right, you get about four or five call backs over the course of the query.

I don't know about other DBMSs such as InterBase, MySQL and so on.

Andrew