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]



Reply via email to