Hi, * Kees Nuyt <k.n...@zonnet.nl> [2010-12-05 22:09:08 +0100]:
> If you need a compound index for performance reasons, you can use > the autoincrement key as the primary key for the table and define a > unique index on the compound key. Is doesn't serve as a constraint > though, because the primary key constraint is more limiting already. Indeed, you guessed right about the performance issue. Should have thought of the unique index possibility. Thanks for clarifying, Kees. Regards Chris _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users