07-01-2009 10:52 AM
I have a huge (20.000 records) database to store in the Blackberry, I already tried to use in the Persistent Store but it is too slow to load all of the records.
Is there any solution to load this data fast or in chunks?
J2ME Record Stores have filters, does the Persistent Store have something too?
tks in advance.
07-01-2009 01:03 PM - edited 07-01-2009 01:05 PM
> How large are the records?
some 100 bytes per record.
> Do the records have a key?
> Primarily indexed access or sequential?
They are created in the server as sequential primary indexed. But in the device I will not be creating new ones, they are just for search.
> Primarily read-only or read-write?
Read-only until now.
07-01-2009 05:36 PM
If you're always accessing the data via the key, you could segment the data into several hashtables (maybe first character of primary key) then store each of the hashtables as a separate persistent object.