Newbie: Application hangs after long delay for SQL Server results

[steve]

Hi,
I have created an application that through a user interface "assembles" a
T-SQL string, sends the querry to the server and fills up a datagrid.
However my querries are (probably) not optimized (and hard to do since the
posibilities through the user choices are endless), so *very* frequently my
application (front end) hangs.

I would like to show some sort of "moving clock" to give the user the idea
of processing. Right now I only change the cursor to an hourglass. Cheap
solution. A progress bar is not a good solution since i do not know
before-hand the time it will take.

Is this a multithreading problem? and if yes are there any god introductory
references?

TIA for your time!
-steve

 

[Cor Ligthert]

Steve,

As long as your solution has the change to hang than I would certainly not
use what you are now after when your program hangs than he will even more
think it is going on.

Multithreading will in my opinion not help you at all with this because you
keep the same behaviour, only that than you thread hangs.

I have showed shortley ago a solution for this with a progresbar, however
because what you said complexibility do I not believe in that as solution
for you.

Cor