B4J Question Busy indicator

[atiaust]

Hi all,

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?

Thanks

 

[Erel]

How many items are you loading to the table?

Can you post the code that fills the table?

 

[atiaust]

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.

Thanks

 

[Erel]

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".

 

[atiaust]

The data file is from a data logger. There shouldn't normally be that many records.

How can I read the data back in blocks? What would the MySQL query be?

Thanks

 

[Daestrum]

How can I read the data back in blocks? What would the MySQL query be?

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).

 

[atiaust]

Thanks
I will give it a try.