Just a note for anyone interested, I originally took the Windows DLL 3.3.5 and benchmarked a particular query. Takes 2.4 seconds on a reasonable dataset.
Took the src, compiled up in VS.NET 2003, with lots of speed optimisations, Pentium 4 and above, SSE on etc. Same query takes 1.6 seconds, so if speed is your prime concern and you know the target machine architecture, you can get some good perf increases by compiling up the src rather than taking the binary as is. And the binary file is actually slightly smaller than the unoptimised DLL taken from the site. -- View this message in context: http://www.nabble.com/Compiler+optimisations-t1710837.html#a4644937 Sent from the SQLite forum at Nabble.com.
