On 4 Jan 2017, at 12:09am, Bart Smissaert <bart.smissa...@gmail.com> wrote:
> Secondly, can the Explain statement tell me that indeed the UDF runs 100000 > times in the first SQL and only once for the second SQL? What makes you think that this is the case ? Why would SQLite not be running the UDF 100000 times in both cases ? Did you build any caching of results into your UDF ? If not, then SQLite has no idea it can optimize it by checking to see if it’s using the same parameters each time. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users