> On Apr 20, 2017, at 11:02 AM, 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, but only for the row being evaluated. It sounds like you’re thinking of json_tree creating a database table that contains all the rows of the real table; that’s not how it works. It simply creates a thing that behaves as a table, whose “rows” are the elements of the JSON collection given as a parameter. After that database row is done being evaluated, the virtual table is disposed. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users