A agb2008 Member Licensed User Longtime User Jul 18, 2015 #1 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.
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 B4X founder Staff member Licensed User Longtime User Jul 19, 2015 #2 agb2008 said: It would be very useful is solution would be applicable to B4A as well. Click to expand... 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 Upvote 0
agb2008 said: It would be very useful is solution would be applicable to B4A as well. Click to expand... 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