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

Sort by date Sort by votes

DonManfred

Expert
Licensed User
Longtime User
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.
 
Upvote 0
R

Rajesh Gupta

Member
Licensed User

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?
 
Upvote 0
R

Rajesh Gupta

Member
Licensed User
Erel said:
You need to provide more information. What exactly are you inserting? Are you keeping it in json format? How is the table created?
Click to expand...

==> 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.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

R
  • Article
Share My Creation Remote SQL Server Interface
Replies
2
Views
3K
rhanger
R
N
  • Question
Android Question B4X Arrow properties
Replies
4
Views
1K
Nitin Joshi
N
  • Article
B4A Library ScaleImageView - Pan and zoom large images
2 3 4
Replies
63
Views
28K
Cebuvi
G
  • Question
Android Question Large Data Transfer over Bluetooth SPP
Replies
1
Views
2K
Erel
  • Article
Android Code Snippet SMTP equal sign and another
Replies
0
Views
3K
MarcoRome
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…