Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Java Development

Reply
Regular Contributor
Posts: 70
Registered: ‎12-19-2011
My Device: Bold 9780
My Carrier: Airtel

need to store data which one is best approch

Hi all

     

I need to 4 tables. one of this tables may have 2000 rows with 10 column.Right now i am using sqlite.But its performance is not good enough.Which one is the best to get the data fast after insertion.

1 Persistance store

2 Record Store

Or there any other way without sdcard to store this data.

 

 

Developer
Posts: 19,636
Registered: ‎07-14-2008
My Device: Not Specified

Re: need to store data which one is best approach

You will find it much easier to manage in PersistentStore. 

 

You might need to think about optimizing the storage a little, if you are planning for this to be put on older devices.  But if you are looking at OS 5.0 and above, then 20,000 Objects should be OK.

 

Are these tables updated or read-only?

Regular Contributor
Posts: 70
Registered: ‎12-19-2011
My Device: Bold 9780
My Carrier: Airtel

Re: need to store data which one is best approach

These tables are updateble in application.

Developer
Posts: 19,636
Registered: ‎07-14-2008
My Device: Not Specified

Re: need to store data which one is best approach

OK, I will stick with the PersistentStore idea.  Do you have any questions on how you would implement this?  The trick is being able to create a structure that can handle the Selects that you need to do. 

Regular Contributor
Posts: 70
Registered: ‎12-19-2011
My Device: Bold 9780
My Carrier: Airtel

Re: need to store data which one is best approach

Thanks peter for reply

 

Till now i am storing object in persistence storage.

I have one question:-How to create structure on PersistentStore and get some particuler data.