How to speedup table population?

[IoSonoPiero]

[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!

 

[Erel]

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

 

[IoSonoPiero]

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.

 

[Erel]

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]

Yes Sir!
I'll try this soon!

 

[IoSonoPiero]

ARGH!!
About 1 second!

I'll do this, thanks!

 

[Erel]

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]

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]

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

I've tested it on my TyTN II!

 

[Erel]

There is a way to save an ordered file?

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]

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

Thank you very much!