On Sun, 20 Oct 2013 16:53:30 +0530 Raheel Gupta <raheel...@gmail.com> wrote:
> I need the inserts to be faster. Faster than what? Why can the existing hardware not be replaced? I would be interested to hear what you find out testing your performance with the primary key in place. I doubt it will be very different, provided you drop the (AIUI unused) index. > So which is better ? An Index or a Primary Key ? In terms of I/O they are identical if the index is unique. Semantically, a primary key declares meaning about the data. it says: those not of the key are true of the key, and are known by the key. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
