Darren Duncan wrote:
I think the simple answer is that SQLite uses a linked list which can't
know where a page is until reading the next one, but other databases use
something other than a linked list; they would trade a bit of complexity
for speed. -- Darren Duncan
The linked-list structure of overflow storage is part of the problem.
But the fact that SQLite uses synchronous I/O is also a factor. In
order to make BLOBs fast in SQLite, I would have to change to a different
indexing technique for overflow storage *and* come up with some kind
of cross-platform, asynchronous disk read mechanism.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]