CPU Core at 100% for entire test, x64 code is ~10% faster than x32 code. So; IO bound things 32/64 doesn't matter so much; but compute bound, through data already in memory gets significant improvments because of addtional general purpose registers and optimal calling conventions for things of fewer than 4 parameters. yields a better usage of your CPU?
and at 10% I said I'd be surprised if more than 5%; but potentially more if I have a thing that fits in cache and I scan a lot? subquery in a select was slower oddly enough... which was mentioned already _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users