Re: [sqlite] SpeedTest1 Comparison of 32 vs 64 bit on Windows 10 13483.15

2016-08-24 Thread Warren Young
On Aug 17, 2016, at 10:38 PM, Keith Medcalf wrote: > > Same code, same compile options, same compiler version > options -s -O3 -pipe -march=native -mtune=native -falign-functions=16 > -falign-loops=16 -flto Ah, good, actual science this time instead of apples-to-oranges. :) Thank you for doing

Re: [sqlite] SpeedTest1 Comparison of 32 vs 64 bit on Windows 10 13483.15

2016-08-23 Thread J Decker
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 few

Re: [sqlite] SpeedTest1 Comparison of 32 vs 64 bit on Windows 10 13483.15

2016-08-19 Thread Dominique Devienne
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

Re: [sqlite] SpeedTest1 Comparison of 32 vs 64 bit on Windows 10 13483.15

2016-08-18 Thread Michael Falconer
Nice Keith, and very topical as well as being informative. Note a couple of things that got my curiosity chip activating: *subquery in result set* test produces interesting outcome with the 64 bit version bucking the trend. Any ideas there? Also it would appear *select* clauses demonstrate an abo

[sqlite] SpeedTest1 Comparison of 32 vs 64 bit on Windows 10 13483.15

2016-08-17 Thread Keith Medcalf
Same code, same compile options, same compiler version options -s -O3 -pipe -march=native -mtune=native -falign-functions=16 -falign-loops=16 -flto 32-bit GCC 4.9.3 >speedtest1 --size 1000 -- Speedtest1 for SQLite 3.15.0 2016-08-17 11:14:39 a861713cc6a3868a1c89240e8340bc 100 - 50 INSERTs