On 20 Jun 2017, at 8:46am, Robert M. Münch <robert.mue...@saphirion.com> wrote:
> The WHERE parts look like this: > > ... WHERE col-1 <> NULL AND col-2 <> NULL ... AND col-x <> NULL > > ... WHERE col-x LIKE ... My bet is that it’s these clauses which are slowing down execution of your command and that the JSON itself isn’t a problem. You might be able to speed up your command by making indexes which allow SQLite to identify the null columns very quickly. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users