B4J Question Save/restore array or list of 10000 float values in sqlite

[agb2008]

I've got a question regarding storing and retrieving array or list (10000 flat values) data to/from sqlite database - what's the best method in terms of speed and performance ? I know that there is no native support for array / list datatype in sqlite db - could you please share your experiance ?

P.S. I need to save this array or list as single reference item in sqlite db... (? string or blob type ?)

P.P.S. It would be very useful is solution would be applicable to B4A as well.

 

[Erel]

It would be very useful is solution would be applicable to B4A as well.

Use KeyValueStore for this. KeyValueStore uses a SQLite database to store the data.

https://www.b4x.com/android/forum/threads/26317/#content
https://www.b4x.com/android/forum/threads/36683/#content