On Fri, Aug 19, 2016 at 3:47 AM, Michael Falconer < michael.j.falco...@gmail.com> wrote:
> *subquery in result set* test produces interesting outcome with the 64 bit > version bucking the trend. Any ideas there? > One cannot tell, unless comparing profiles of both. One thing to remember is that pointer-heavy data structures can be up to twice as big in memory in 64 bit, sometimes not fitting in cache anymore, and therefore negatively affecting performance at times. So gains from using the 64-bit chip "natively" can be lost to those cache misses. Just a broad generic statement of 32 vs 64-bit. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users