Guillaume Fougnies wrote:
Hello,
I run a simple benchmark between sqlite 3.0.3 and sqlite
2.8.15 using synchronous OFF and i get a performance decrease
of ~20%. How can it be explained? the new file format?
Version 3.0 trades CPU cycles for disk I/O. So if you have a
fast CPU and a slow disk, version 3.0 will be faster. If you
have a fast disk and a slow CPU, version 3.0 will be slower.
For a typical workstation, there is usually not much change.
Historical trends are for CPUs to gain speed faster than
disks. So the tradeoff seems reasonable moving forward.
But as always, your mileage may vary...
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
