SQuirreL SQL Client

Hi all!

Sometimes the loading of the contents in the objecttree's tabs takes a long 
time, i.e. when retrieving the contents of a complex database view. So I've 
thought about a dialog that gives the user feedback about the query taking 
place.

If there's no dialog, the user can very likely produce a queue of queries with 
no feedback by clicking several tabs in the objecttree very fast one after 
another.

In the attached patch I've got a solution for the "Table Contents" tab. That 
would some work to be production stable, but first I want to have your 
feedback about such a feature. ;-)

Greetings,

Thorsten

Re: [Squirrel-sql-develop] Activity dialog while retrieving tab contents From: Robert Manning <robert.manning@gm...> - 2007-04-29 19:03 On 4/29/07, Thorsten M=FCrell <thorsten.muerell@...> wrote: > Hi all! > > Sometimes the loading of the contents in the objecttree's tabs takes a lo= ng > time, i.e. when retrieving the contents of a complex database view. So I'= ve > thought about a dialog that gives the user feedback about the query takin= g > place. > > If there's no dialog, the user can very likely produce a queue of queries= with > no feedback by clicking several tabs in the objecttree very fast one afte= r > another. It's a nice idea. I've seen novice users stumble upon this before. One suggestion I have would be to not dispose of the dialog until the end of ContentsTab.createDataSet(); in a finally block as you did before. Otherwise, the dialog displays for a second then I see nothing for another 3-4 seconds and finally the data is loaded. This might be an edge case as my setup is a local database with ~15K rows and I was displaying them all. Maybe we could get an animated gif graphic with turning wheels or something. Rob

Re: [Squirrel-sql-develop] Activity dialog while retrieving tab contents From: Thorsten <thorsten.muerell@gm...> - 2007-04-29 19:26 > > Sometimes the loading of the contents in the objecttree's tabs takes a > > long time, i.e. when retrieving the contents of a complex database view. > > So I've thought about a dialog that gives the user feedback about the > > query taking place. > > > > If there's no dialog, the user can very likely produce a queue of queries > > with no feedback by clicking several tabs in the objecttree very fast one > > after another. > > It's a nice idea. I've seen novice users stumble upon this before. > One suggestion I have would be to not dispose of the dialog until the > end of ContentsTab.createDataSet(); in a finally block as you did > before. Otherwise, the dialog displays for a second then I see > nothing for another 3-4 seconds and finally the data is loaded. This > might be an edge case as my setup is a local database with ~15K rows > and I was displaying them all. Maybe we could get an animated gif > graphic with turning wheels or something. Yes, that would be very nice. I thought of a never ending progress bar... I will try to move the dialog hiding after the whole creation of the data set. Another issue is that the dialog is not forced in front of the session window. So if you click into the session window, the dialog gets behind it. I'll see how I can prevent this. Greetings, Thorsten

Re: [Squirrel-sql-develop] Activity dialog while retrieving tab contents From: <thorsten.muerell@gm...> - 2007-05-01 22:01 Attachments: 20070501_pleasewait_dialog.patch.txt      > > Sometimes the loading of the contents in the objecttree's tabs takes a > > long time, i.e. when retrieving the contents of a complex database view. > > So I've thought about a dialog that gives the user feedback about the > > query taking place. > > > > If there's no dialog, the user can very likely produce a queue of queries > > with no feedback by clicking several tabs in the objecttree very fast one > > after another. > > It's a nice idea. I've seen novice users stumble upon this before. > One suggestion I have would be to not dispose of the dialog until the > end of ContentsTab.createDataSet(); in a finally block as you did > before. Otherwise, the dialog displays for a second then I see > nothing for another 3-4 seconds and finally the data is loaded. This > might be an edge case as my setup is a local database with ~15K rows > and I was displaying them all. Maybe we could get an animated gif > graphic with turning wheels or something. I've now moved the disposal of the dialog to the bottom of the createDataSet() method and put the dialog into the MODAL_LAYER of the desktop to have it on top of the session window. May I commit this version into CVS? Greetings, Thorsten

Re: [Squirrel-sql-develop] Activity dialog while retrieving tab contents From: Robert Manning <robert.manning@gm...> - 2007-05-01 22:32 On 5/1/07, "Thorsten M=FCrell" <thorsten.muerell@...> wrote: > I've now moved the disposal of the dialog to the bottom of the createData= Set() > method and put the dialog into the MODAL_LAYER of the desktop to have it = on > top of the session window. > > May I commit this version into CVS? I have no objections. Rob

1 message has been excluded from this view by a project administrator.