> 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

Reply via email to