On 10/29/15, Jason H <jhihn at gmx.com> wrote: > > Ah, so this is what I seem to have missed. The pages... This is unfortunate > as the read-heavy application won't likely benefit from SQLite.
Your filesystem and your disk hardware work the same way. Your application might only ask for 10 bytes, but the underlying OS and hardware are pulling a complete sector (or perhaps a complete track) from disk, pass the 10 bytes you asked for off to your app, and holding the rest in cache. So, no, you cannot improve performance by only reading a few bytes here and a few bytes there. The disk has to work just as hard. -- D. Richard Hipp drh at sqlite.org