On 10/19/13, Raheel Gupta <raheel...@gmail.com> wrote: > Does SQLite support multi column primary keys ?
Yes. > Also wouldnt primary keys actually slow down further inserts. I have > queries to insert nearly 10000 rows in one second. With larger database > multi column primary keys might slow down right ? Not really, not more than it would if you had an ordinary index on the same columns. A primary key is almost the same as a separate unique index in sqlite. Once you have an index, sqlite has to store inserted records in the index anyway, and then if that index is unique it can check the neighbouring entries in the index when it's doing the insertion. Ambrus _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
