On 4/20/17, Akshat Jiwan Sharma <akshatji...@gmail.com> wrote: > Does that mean that the json_tree table is stored in memory after the json > is parsed by sqlite?
Yes. > > If so, for querying json data will I be limited by the memory of my > machine? How big are your JSON strings that storing the entire string in memory at once is a problem? > > Is there any way to measure the size of this table? > Do you mean, how much memory does it use? You might use the sqlite3_memory_used() interface before and after starting the virtual table in order to figure that out. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users