On 2016-02-08 04:31, Roger Binns wrote: > On 07/02/16 00:56, Dominique Pell? wrote: >> I'm curious about the outcome on SQLite benchmarks. > > About a year ago I tried them out on some tight code (non-SQLite) that > absolutely had to use less CPU time. I couldn't get them to make any > difference outside the bounds of measurement error. Since SQLite has > lots of "tight code" places, the instrumentation would have to help in > most of them to make a difference (Amdahl's law).
Amdahl's law is not applicable here and describes a completely different problem. SQLite does not involve concurrency. In typical scenarios SQLite is also limited by the number of IOPS and optimization to improve branch predictability have no measurable effect and you just waste time with them. Just use PCIe SSDs that are able to saturate the bus and all of you performance problems with SQLite are gone if you use SQLite on typical computer. - Matthias-Christian -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 181 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160208/2dd38072/attachment.pgp>
