Android Question Is it reliable to store large amount of JSON in Sqlite Database in Tabular form?

[Rajesh Gupta]

Anybody Please let me Know?

Thanks.

 

[DonManfred]

Note that sqlite has an limit in cursorsize.
It is not recommenden to put a json with 1000 datasets into one database field.

It would be much faster if you split the json and create table entries based on the data in the json. Faster afterwards as you can directly query the database.

 

[Rajesh Gupta]

Note that sqlite has an limit in cursorsize.
It is not recommenden to put a json with 1000 datasets into one database field.

It would be much faster if you split the json and create table entries based on the data in the json. Faster afterwards as you can directly query the database.

Also i would like to ask that when i am inserting around 750 rows in a table in sqlite databse , the size of the data is around 65MB, which is too much, How come this is possible?

 

[Erel]

You need to provide more information. What exactly are you inserting? Are you keeping it in json format? How is the table created?

 

[Rajesh Gupta]

You need to provide more information. What exactly are you inserting? Are you keeping it in json format? How is the table created?

==> CREATE TABLE tblLedgers (PARTYNAME TEXT, PARTYJSON MEMO , VCHJSON MEMO )

These are the fields in table..

And PartyJSON and VchJSON fields contains a large json data , and i store around 750 rows of data in sqlite databse.. and the size which is shown on phone is around 65 MB.

 

[Erel]

You can compress the json strings with CompressStreams.CompressBytes and store them as blobs.