*Does the JSON data need to be indexed/queried?* -> Some background about the data what we store; till now we were storing the data in a specific native data structure in a binary file. Now to turn to modern databases we are testing with databases for example couchbase lite and convert this data to json object for now and store it. And when we read then we again convert it to our native data structure format. (legacy system pain sob sob..) Coming to question; the data what we store has some meta data like name,type,datemodified so these meta data are queried often; rest of the data should be in its native format so that system can understand. So yes some amount of query required. indexing not sure; may be if we have it then we can have better read performance?
* If not, you can store it in an attachment.* how the system will behave in terms of syncing? since we have multi user scenario (mainly cause of which we are looking at couchbase lite) and if we store it as attachments how will it affect it? How will be the speed or performance? Main challenge here is the performance since the software of ours is heavy calculation intensive software so need to be fast. *your app can just read the attachment as a blob and run it through a JSON parser. (Or use some other encoding format; JSON isn't very efficient.)* Hmm right now we are always converting our native format to json format (a bit of overhead); so if not JSON do you suggest something else? I had it so that we can only store it as JSON only. And I have a doubt now: I see the .net API and the PutLocalDocument take paramter as Dictionary<string,object> so this object can be any C# object type? or should be in a specific json format? (may be a dumb question) Thanks On Wednesday, 20 August 2014 23:54:12 UTC+5:30, Jens Alfke wrote: > > > On Aug 20, 2014, at 10:44 AM, Sherry Ummen <[email protected] > <javascript:>> wrote: > > Now in our case we are writting as Json objects and dumping it to the > couchbase lite sqllite and this json object can sometimes be huge depending > on the size of the project which as user is workiing on. So do you say or I > am wrongly interpretting that Couchbase lite is not a good fit for this > purpose? > > > Does the JSON data need to be indexed/queried? If not, you can store it in > an attachment. Then your app can just read the attachment as a blob and run > it through a JSON parser. (Or use some other encoding format; JSON isn't > very efficient.) > > If it has a small subset that needs to be queried, you can store that > subset as actual document properties and keep the rest as an attachment. > > —Jens > -- You received this message because you are subscribed to the Google Groups "Couchbase Mobile" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/mobile-couchbase/75fb7a5c-b53c-4bc0-9111-572498d66be5%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
