> What makes you think that this is the case ? I didn't check, but this was the only explanation I could think of. Will check in a bit.
RBS On Wed, Jan 4, 2017 at 12:17 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
