I'm using the JSON1 extension, and I want to find items by json array contents.
This means a query like `*SELECT foo.json FROM foo, json_each(foo.json) WHERE json_each.value = "bar";*`, so basically scanning the entire table. I understand that virtual tables can not be indexed, so what other approaches would be possible here to prevent such a slow operation? There doesn't seem to be a way to generate multiple values for a single row in an index… Wout. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
