How to speedup table population?

IoSonoPiero

Active Member

Licensed User

Longtime User

• Jul 24, 2009

• #1

[Solved] How to speedup table population?

Hello,
I've tried on real device and on the emulator to populate a table with two columns.

To fill 477 rows, it takes 7 seconds.

I use: table.AddRow (value1, value2)

There is a way to speedup the process or this is the normal speed of populating function?

There is some trick (i.e. hide the table before the population process) to give me more speed?

Thanks to this great forum!

 

Last edited: Jul 24, 2009

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jul 24, 2009

• #2

Where does the data come from?
Loading it with Table.LoadCSV or from SQL with Command.ExecuteTable could be faster.

 

IoSonoPiero

Active Member

Licensed User

Longtime User

• Jul 24, 2009

• #3

Hello Erel,
the data are loaded from a file into an array.

Then the table is populated getting data from the bidimensional array.
The data can't be loaded with LoadCSV function.

 

Last edited: Jul 24, 2009

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jul 24, 2009

• #4

I recommend you to do the following test:
- Load the data.
- Save the table with Table.SaveCSV.
- Now run your program and load the CSV file. See how much faster (if at all) it will run.

If it does run significantly faster than you can consider converting your file to a CSV file (maybe to a temporary file on the run) and then load it with LoadCSV.

 

IoSonoPiero

Active Member

Licensed User

Longtime User

• Jul 24, 2009

• #5

Yes Sir!
I'll try this soon!

 

IoSonoPiero

Active Member

Licensed User

Longtime User

• Jul 24, 2009

• #6

ARGH!!
About 1 second!

I'll do this, thanks!

 

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jul 24, 2009

• #7

Make sure to run your tests on an optimized compiled executable. It runs much faster compared to running the source code in the IDE.

Edit: Wrote this post before reading your previous one.

 

IoSonoPiero

Active Member

Licensed User

Longtime User

• Jul 24, 2009

• #8

Mmmhhh, the table is sorted for the first column.

I' ve noticed that the Table.SaveCSV save the content, but this isn't ordered.

There is a way to save an ordered file?

 

IoSonoPiero

Active Member

Licensed User

Longtime User

• Jul 24, 2009

• #9

Erel said:

Make sure to run your tests on an optimized compiled executable. It runs much faster compared to running the source code in the IDE.

Click to expand...

I've tested it on my TyTN II!

 

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jul 24, 2009

• #10

There is a way to save an ordered file?

Click to expand...

Not a very good one. But you can always sort it after loading the data.

You can go over all the visible rows and add them to another table. Then save the second table. You can also create the CSV file yourself. It is pretty simple if your data doesn't include quotes and commas.

 

IoSonoPiero

Active Member

Licensed User

Longtime User

• Jul 24, 2009

• #11

I can confirm that using the LoadCSV it's INCREDIBLY FAST!

Thank you very much!