CODEWITHSUNDEEP
vb.netjson
Amit Pore
Amit Pore

Reputation: 127

Compressing JSON

I am saving long Json string into DB , fetching the string from Db and then serializing it for other manipulation is making it slow.

Is there any good solution to do that.

Upvotes: 0

Views: 289

Answers (2)

n1ckolas
n1ckolas

Reputation: 4440

As there was told, you might need to use Documented-Oriented DB, like MongoDB.

If you can't do this, please consider combined data storage: something you may store in RDBMS, something - in MongoDB.

And if it is impossible for certain reasons, please look at binary formats of JSON: Smile or BSON, both of which are supported by various frameworks, such as JSON.Net (article for consideration http://james.newtonking.com/archive/2009/12/26/json-net-3-5-release-6-binary-json-bson-support.aspx)

Upvotes: 1

Meti
Meti

Reputation: 365

The best possible way is to use a document oriented database which support json for storage. This way you can query or update part of the long json without fetching or serializing it.

Upvotes: 0

Related Questions