How do I make my GUI more responsive?

[CidTek]

Just before doing a SQL lookup I show a ProgressDialog (even tried a ToastMessage) and neither pop until the SQL select and listview populating are finished. So I get long pause of nothing then quick flash of my dialog and the populated listview shows. I even tried a Doevents before executing the query.

 

[Erel]

What takes longer the SQL query or populating the listview?
How many items are you adding?

 

[CidTek]

What takes longer the SQL query or populating the listview?
How many items are you adding?

The SQL query (about 25 seconds). I add about 12 rows to the listview.

 

[Erel]

25 seconds is very very slow.
Can you post your query?
Maybe you can add an index to one of the columns.

 

[CidTek]

25 seconds is very very slow.
Can you post your query?
Maybe you can add an index to one of the columns.

It's a 11 meg db with 5 tables and the query has several joins. The result set is used to do another select while looping through the first cursor so I'm not surprised at all by the speed. The tables are indexed.

But the question is why does my ProgressDialog which is popped before the search not show until after it's done.

 

[Cableguy]

I have a similar issue, with progressbarsow....
I call it in activity main, so that the user knows that something is beeig done, and then inthe trget activity, I call progressbarhide as the last line of Activity create...the progressbar gets hidden before the layout is loaded!
is there anyway to catch, displayready alike event?

 

[agraham]

But the question is why does my ProgressDialog which is popped before the search not show until after it's done.

To show the ProgressDialog the app has to get back to run the message loop. The only way to do this in linear code is to call DoEvents after showing the dialog and at intervals within your long loop to let it update.

 

[CidTek]

I have a similar issue, with progressbarsow....
I call it in activity main, so that the user knows that something is beeig done, and then inthe trget activity, I call progressbarhide as the last line of Activity create...the progressbar gets hidden before the layout is loaded!
is there anyway to catch, displayready alike event?

Even though this may be a similar issue, the problem with thread hijacking is any answer to your issue may lead readers to think my issue is resolved if they only come back to the last unread answer. if you wish to continue discussing your progressbar problem could you please start a new thread?