I want to show a small progress indicator while a database is loaded to a table so that the user can see something is happening, like a mouse pointer timer or similar any ideas?
Hi Erel,
I am loading 79,600 records from a Raspberry Pi Mysql server over WIFI.
It takes about 20 seconds to fill the table which is pretty good.
I am using form.showAndWait to keep the form on top and have to load the table before showing the form.
Tried showing the form first but the data doesn't show.
Would like to show a spinner while data is loading.
Loading 80k records to TableView will cause your app to freeze. You haven't posted the code so it is impossible to say whether it can be improved or not.
It will probably be better to only load a few hundred records to the table view. What can the user do with 80k rows? Split it into multlple "pages".
If I remember correctly you can use LIMIT with 2 parameters. ie SELECT * from .... LIMIT 1,10
I think the first param is the offset and the second is the number of rows to return. (Worth a google to confirm).