On Sun, 20 Oct 2013 17:08:09 +0400 Yuriy Kaminskiy <yum...@gmail.com> wrote:
> > The new INDEX that I created on your suggestion with d,n,s solves > > the problem. > > Now the question is over Primary key whether that will slow it down > > or not. > > Only question is whether you have *other* queries that prefers *old* > index. If not - you can just drop old index and save time on insert. Good advice. Sometimes it's easy to forget that improving one thing can harm another. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
