Is there any gotcha, any disadvantage (query complexity, db size,
query speed) to using a composite PK (two columns) vs. a single
AUTOINCREMENT INT?

Background: I happen to have the two columns in question in my table
anyway. Adding an INTEGER PRIMARY KEY would use up space I don't want
to use. My db is big enough to worry about space from a single field.

-- 
Puneet Kishor
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to