On Wed, May 6, 2009 at 7:36 PM, D. Richard Hipp <d...@hwaci.com> wrote: > SQLite version 3.6.14 is now available on the SQLite website > > http://www.sqlite.org/ > > Version 3.6.14 contains performance enhances in the btree and pager > subsystems. In addition, the query optimizer now knows how to take > advantage of OR and IN operators on columns of a virtual table. > > A new optional extension is included that implements an asynchronous I/ > O backend for SQLite on either windows or unix. The asynchronous I/O > backend processes all writes using a background thread. This gives > the appearance of faster response time at the cost of durability and > additional memory usage. See http://www.sqlite.org/asyncvfs.html for > additional information.
Asynchronous I/O is already the name of some advanced I/O APIs designed for high scalability, where you start an I/O operation and are notified when it completes. Some databases use this form of I/O, so it might be even more confusing if developers are expecting the performance perks and features it provides. Might I suggest calling this "delayed" I/O as MySQL does (see INSERT DELAYED)? Or maybe "deferred", I always thought that was a better name for it. Thanks for the new release! -- Cory Nelson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
