On 30 Jul 2018, at 10:25am, Dominique Devienne <ddevie...@gmail.com> wrote:
> The former allows you to get what you want, but as you wrote, you must > rewrite your queries. The latter, > if supported, would allow to move the "function definition" to the column, > and index the vcolumn directly. It's the usual speed vs. filespace issue. And as usual it comes down to how speed-critical searches are how often you do searches, and relative frequency of making changes vs. searching A later post from OP suggests that the critical point here really is filespace, not search time, so my previous recommendation is perhaps not appropriate for this situation. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users