> On Jun 19, 2017, at 6:50 AM, Robert M. Münch <[email protected]> > wrote: > > This view works and of course takes some time to build.
My understanding from reading the docs is that SQLite view’s aren’t “built” at all: their contents have no physical existence in the database, the views are simply macros that transform the statements that use them. (Correct me if I’m wrong; I haven’t actually used views.) > Can the JSON1 extension be supported by adding indices or whatever, that > speeds-up the VIEW construction/updates? You can create indexes to support JSON1 queries by using the same json_xx function calls in a CREATE INDEX statement. —Jens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
