Speed improvements based on 64-bit Visual Studio build.
SQLite 3.14.0, built with MSVC 18.00.30723 for x64.
Built with VS options /O2 /Ot /Ox.
Built with SQLITE options of SQLITE_ENABLE_FTS3 SQLITE_ENABLE_STAT2
SQLITE_ENABLE_RTREE.
Module SQL Script (146k records) T1 Sec T2 Sec T3 Sec T4 Sec Sp Inc
Sp Inc Sp Inc
Processing Module 1 of 8: (CTEs) 138 110 96 56
125% 144% 246%
Processing Module 2 of 8: 26 20 18 15 130%
144% 173%
Processing Module 3 of 8: 34 28 26 21 121%
131% 162%
Processing Module 4 of 8: 14 7 7 6 200%
200% 233%
Processing Module 5 of 8: 9 6 5 4 150%
180% 225%
Processing Module 6 of 8: 30 14 13 11 214%
231% 273%
Processing Module 7 of 8: (CTEs) 290 222 194 100 131%
149% 290%
Processing Module 8 of 8: 14 14 11 11 100%
127% 127%
Total Processing Time: 557 424 372 227 131%
150% 245%
Test 1: 32-Bit 3.13 (sqlite.org), No PRAGMA (Baseline)
Test 2: 64-bit 3.14.0 Visual Studio 18, No PRAGMA
Test 3: 64 bit 3.14.0 Visual Studio 18, with PRAGMA but not temp_store = 2;
Test 4: 64 bit 3.14.0 Visual Studio 18, all PRAGMA
PRAGMAs used...
PRAGMA synchronous = 0;
PRAGMA read_uncommitted = 1;
PRAGMA locking_mode = exclusive;
PRAGMA journal_mode = Off;
PRAGMA temp_store = 2;
I am still trying to figure out how to make a 64-bit build in MinGW. There is
a nice installer for 32-bit but not for 64-bit, go figure.
Hopefully I have the PRAGMAs right. If there is a better configuration for
speed, let me know.
Richard
This communication is the property of CenturyLink and may contain confidential
or privileged information. Unauthorized use of this communication is strictly
prohibited and may be unlawful. If you have received this communication in
error, please immediately notify the sender by reply e-mail and destroy all
copies of the communication and any attachments.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
