Hi sqlite-users community, I was looking at the json1 extension and came to know that json_tree <https://sqlite.org/json1.html#jtree> is implemented as a virtual table. Does that mean that the json_tree table is stored in memory after the json is parsed by sqlite?
If so, for querying json data will I be limited by the memory of my machine? What happens when json_tree is unable to parse all the json rows in the database, that is the size of the json columns increase the memory on the machine? Is there any way to measure the size of this table? Thanks, Akshat _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
