On Tue, May 27, 2014 at 10:49 PM, Richard Hipp <d...@sqlite.org> wrote: > On Tue, May 27, 2014 at 10:50 AM, Richard Hipp <d...@sqlite.org> wrote: >> > > This time I build the 32-bit DLL using mingw instead of MSVC. (MSVC was > still used for the 64-bit DLL.) So perhaps it will work correctly on > WinXP. Please let me know one way or the other. Thanks. >
Don't know what is difference between "stock" 3.8.4.3 from the site and the newly compiled one, but synthetic tests with memory databases (no I/O involved) show that the new one is about 20% faster (Intel Core i5-2310). If they're both MinGW built then probably some switch differences between these builds (if there are any) gives such difference. Here is the schema and the timings. The first one is for sqlite-dll-win32-x86-3080403.zip, the second one is for sqlite-dll-win32-x86-201406021126.zip The table in memory CREATE TABLE [TestTable] ([ID] Integer primary key, [IntValue] INTEGER, [FloatValue] FLOAT, [StrValue] TEXT) was populated with 1000 pseudo-random rows using the same seed for every test. The following queries all use cross join and differ in types of data used (int, float, string) Select Count(*) FROM (SELECT * FROM TestTable T1 Join TestTable T2 ) 62 msec 47 msec Select Count(*) FROM (SELECT *,t1.FloatValue / t2.FloatValue as divvalue FROM TestTable T1 Join TestTable T2 where abs(divvalue - round(divvalue)) > 0.499) 453 msec 359 msec Select Count(*) FROM (SELECT * FROM TestTable T1 Join TestTable T2 where (T1.IntValue * T2.IntValue) % 1789 = 56) 203 msec 187 msec Select Count(*) FROM (SELECT * FROM TestTable T1 Join TestTable T2 where substr(t1.strvalue, 1 + t1.intvalue % 20, 1 + t2.intvalue % 20) = t2.strvalue) 499 msec 405 msec Select Count(*) FROM (SELECT *,t1.FloatValue / t2.FloatValue as divvalue FROM TestTable T1 Join TestTable T2 where abs(divvalue - round(divvalue)) > 0.499 or (T1.IntValue * T2.IntValue) % 1789 = 56 or substr(t1.strvalue, 1 + t1.intvalue % 20, 1 + t2.intvalue % 20) = t2.strvalue) 1124 msec 952 msec Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
