> On Sep 13, 2019, at 1:30 PM, Keith Medcalf <kmedc...@dessus.com> wrote: > > The only thing that is clear is that where the overhead of executing each > select is significant it is clearly better to execute fewer of them.
Thanks for the research, Keith! In my case the per-query overhead is lower since I'm using the C interface, but I'm betting that it's still nontrivial, so I've decided to go with the "dynamic in" approach. From your measurements it doesn't look like further optimizations like carray are worth it. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
