On Tue, 9 Dec 2014 10:38:34 -0500 "James K. Lowden" <jklow...@schemamania.org> wrote:
> On Tue, 09 Dec 2014 12:06:20 +0100 > Jan Stan?k <jsta...@redhat.com> 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 <emorr...@yahoo.es> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users