On Tue, 9 Dec 2014 10:38:34 -0500 "James K. Lowden" <[email protected]> wrote:
> On Tue, 09 Dec 2014 12:06:20 +0100 > Jan Stan?k <[email protected]> wrote: > > > INSERT INTO CoreCache (ModelID, ItemID) > > SELECT > ... > > ORDER BY Year > > Why ORDER BY on INSERT? Does it work better? I would expect the > unnecessary sort to be pure overhead. If you insert in correct index order, the index update phase is faster because it don't need rebalance the b-tree so often after each insert. --- --- Eduardo Morras <[email protected]> _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
