On Saturday, 5 March, 2016 12:12, Richard Hipp said: > A key point of this email thread is that SQLite performance seems to > be maximized when the database page size matches the CPU memory page > size and the disk sector size - currently 4096 bytes on most hardware.
This does not seem to be entirely true, at least not on Windows 10 1511 Pro with a running on a very fast SSD. I suspect it is more related to the size and shape of the data being stored and the operations being performed. Clearly the best thing that can be done to improve performance is increase the internal pagecache. These are benchmark times for --size 500 on Windows 10 ... Time= 66.81, Cachesize= 65536, Pagesize= 8192, Cacheram=536870912 Time= 67.10, Cachesize= 32768, Pagesize= 8192, Cacheram=268435456 Time= 67.37, Cachesize= 4096, Pagesize= 8192, Cacheram=33554432 Time= 67.92, Cachesize= 8192, Pagesize= 8192, Cacheram=67108864 Time= 68.00, Cachesize= 16384, Pagesize= 8192, Cacheram=134217728 Time= 68.31, Cachesize= 131072, Pagesize= 8192, Cacheram=1073741824 Time= 69.08, Cachesize= 16384, Pagesize=16384, Cacheram=268435456 Time= 69.71, Cachesize= 131072, Pagesize= 4096, Cacheram=536870912 Time= 69.82, Cachesize= 16384, Pagesize= 4096, Cacheram=67108864 Time= 69.90, Cachesize= 8192, Pagesize=16384, Cacheram=134217728 Time= 70.00, Cachesize= 32768, Pagesize=16384, Cacheram=536870912 Time= 70.04, Cachesize= 4096, Pagesize=16384, Cacheram=67108864 Time= 70.85, Cachesize= 65536, Pagesize=16384, Cacheram=1073741824 Time= 70.91, Cachesize= 2048, Pagesize=16384, Cacheram=33554432 Time= 70.98, Cachesize= 8192, Pagesize= 4096, Cacheram=33554432 Time= 71.32, Cachesize= 32768, Pagesize= 4096, Cacheram=134217728 Time= 71.34, Cachesize= 65536, Pagesize= 4096, Cacheram=268435456 Time= 71.73, Cachesize= 262144, Pagesize= 4096, Cacheram=1073741824 Time= 73.90, Cachesize= 1024, Pagesize=16384, Cacheram=16777216 Time= 74.24, Cachesize= 65536, Pagesize= 2048, Cacheram=134217728 Time= 74.25, Cachesize= 262144, Pagesize= 2048, Cacheram=536870912 Time= 74.32, Cachesize= 32768, Pagesize= 2048, Cacheram=67108864 Time= 74.37, Cachesize= 131072, Pagesize= 2048, Cacheram=268435456 Time= 74.94, Cachesize= 4096, Pagesize= 4096, Cacheram=16777216 Time= 74.95, Cachesize= 32768, Pagesize=32768, Cacheram=1073741824 Time= 75.13, Cachesize= 16384, Pagesize= 2048, Cacheram=33554432 Time= 75.15, Cachesize= 2048, Pagesize= 8192, Cacheram=16777216 Time= 75.68, Cachesize= 524288, Pagesize= 2048, Cacheram=1073741824 Time= 76.14, Cachesize= 4096, Pagesize=32768, Cacheram=134217728 Time= 76.46, Cachesize= 1024, Pagesize=32768, Cacheram=33554432 Time= 76.87, Cachesize= 2048, Pagesize=32768, Cacheram=67108864 Time= 77.37, Cachesize= 16384, Pagesize=32768, Cacheram=536870912 Time= 79.96, Cachesize= 8192, Pagesize=32768, Cacheram=268435456 Time= 81.68, Cachesize= 8192, Pagesize= 2048, Cacheram=16777216 Time= 82.30, Cachesize= 1024, Pagesize= 8192, Cacheram=8388608 Time= 82.41, Cachesize= 2048, Pagesize= 4096, Cacheram=8388608 Time= 83.95, Cachesize= 524288, Pagesize= 1024, Cacheram=536870912 Time= 84.06, Cachesize=1048576, Pagesize= 1024, Cacheram=1073741824 Time= 84.19, Cachesize= 512, Pagesize=32768, Cacheram=16777216 Time= 84.57, Cachesize= 131072, Pagesize= 1024, Cacheram=134217728 Time= 84.59, Cachesize= 262144, Pagesize= 1024, Cacheram=268435456 Time= 84.90, Cachesize= 65536, Pagesize= 1024, Cacheram=67108864 Time= 85.62, Cachesize= 32768, Pagesize= 1024, Cacheram=33554432 Time= 88.04, Cachesize= 512, Pagesize=16384, Cacheram=8388608 Time= 89.12, Cachesize= 4096, Pagesize= 2048, Cacheram=8388608 Time= 90.95, Cachesize= 16384, Pagesize= 1024, Cacheram=16777216 Time= 92.78, Cachesize= 512, Pagesize= 8192, Cacheram=4194304 Time= 92.83, Cachesize= 16384, Pagesize=65536, Cacheram=1073741824 Time= 93.09, Cachesize= 1024, Pagesize= 4096, Cacheram=4194304 Time= 93.96, Cachesize= 4096, Pagesize=65536, Cacheram=268435456 Time= 96.18, Cachesize= 8192, Pagesize=65536, Cacheram=536870912 Time= 96.24, Cachesize= 512, Pagesize=65536, Cacheram=33554432 Time= 96.67, Cachesize= 2048, Pagesize=65536, Cacheram=134217728 Time= 97.21, Cachesize= 256, Pagesize=16384, Cacheram=4194304 Time= 98.09, Cachesize= 1024, Pagesize=65536, Cacheram=67108864 Time= 99.55, Cachesize= 256, Pagesize=32768, Cacheram=8388608 Time=100.18, Cachesize= 2048, Pagesize= 2048, Cacheram=4194304 Time=102.00, Cachesize= 256, Pagesize= 8192, Cacheram=2097152 Time=102.25, Cachesize= 512, Pagesize= 4096, Cacheram=2097152 Time=103.90, Cachesize= 524288, Pagesize= 512, Cacheram=268435456 Time=104.04, Cachesize=2097152, Pagesize= 512, Cacheram=1073741824 Time=104.36, Cachesize=1048576, Pagesize= 512, Cacheram=536870912 Time=105.46, Cachesize= 131072, Pagesize= 512, Cacheram=67108864 Time=106.14, Cachesize= 65536, Pagesize= 512, Cacheram=33554432 Time=106.17, Cachesize= 262144, Pagesize= 512, Cacheram=134217728 Time=107.06, Cachesize= 128, Pagesize= 8192, Cacheram=1048576 Time=108.26, Cachesize= 256, Pagesize=65536, Cacheram=16777216 Time=108.50, Cachesize= 128, Pagesize=16384, Cacheram=2097152 Time=109.64, Cachesize= 1024, Pagesize= 2048, Cacheram=2097152 Time=110.19, Cachesize= 256, Pagesize= 4096, Cacheram=1048576 Time=111.94, Cachesize= 8192, Pagesize= 1024, Cacheram=8388608 Time=113.59, Cachesize= 32768, Pagesize= 512, Cacheram=16777216 Time=114.52, Cachesize= 64, Pagesize= 8192, Cacheram=524288 Time=115.55, Cachesize= 512, Pagesize= 2048, Cacheram=1048576 Time=115.78, Cachesize= 64, Pagesize=16384, Cacheram=1048576 Time=118.38, Cachesize= 128, Pagesize=32768, Cacheram=4194304 Time=119.21, Cachesize= 128, Pagesize= 4096, Cacheram=524288 Time=120.83, Cachesize= 4096, Pagesize= 1024, Cacheram=4194304 Time=124.15, Cachesize= 256, Pagesize= 2048, Cacheram=524288 Time=128.50, Cachesize= 64, Pagesize= 4096, Cacheram=262144 Time=128.73, Cachesize= 2048, Pagesize= 1024, Cacheram=2097152 Time=131.05, Cachesize= 64, Pagesize=32768, Cacheram=2097152 Time=136.87, Cachesize= 1024, Pagesize= 1024, Cacheram=1048576 Time=137.83, Cachesize= 128, Pagesize= 2048, Cacheram=262144 Time=139.69, Cachesize= 128, Pagesize=65536, Cacheram=8388608 Time=142.58, Cachesize= 512, Pagesize= 1024, Cacheram=524288 Time=145.31, Cachesize= 16384, Pagesize= 512, Cacheram=8388608 Time=158.11, Cachesize= 256, Pagesize= 1024, Cacheram=262144 Time=159.01, Cachesize= 8192, Pagesize= 512, Cacheram=4194304 Time=162.93, Cachesize= 64, Pagesize= 2048, Cacheram=131072 Time=165.70, Cachesize= 4096, Pagesize= 512, Cacheram=2097152 Time=166.69, Cachesize= 64, Pagesize=65536, Cacheram=4194304 Time=178.94, Cachesize= 2048, Pagesize= 512, Cacheram=1048576 Time=182.30, Cachesize= 128, Pagesize= 1024, Cacheram=131072 Time=188.52, Cachesize= 1024, Pagesize= 512, Cacheram=524288 Time=202.82, Cachesize= 512, Pagesize= 512, Cacheram=262144 Time=224.85, Cachesize= 256, Pagesize= 512, Cacheram=131072 Time=229.47, Cachesize= 64, Pagesize= 1024, Cacheram=65536 Time=272.45, Cachesize= 128, Pagesize= 512, Cacheram=65536 Time=355.64, Cachesize= 64, Pagesize= 512, Cacheram=32768
