Raheel Gupta wrote: >> Yes, but they allow the searches to be faster. You are making it longer >> to do INSERT but shorter to do SELECT. Which is best for you depends on >> your purposes. >> > > I need the inserts to be faster. > So which is better ? An Index or a Primary Key ?
Is there any difference between UNIQUE INDEX and PRIMARY KEY *in sqlite*? [except for special-case INTEGER PRIMARY KEY, which is not applicable here] > 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. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
