Re: [sqlite] Compound primary key problem

On 3 May 2011, at 5:56pm, Paul Shaffer wrote: > This is a mapping table or descriptor table or whatever you want to call > it, between 2 tables (about 120,000 rows). I'm finding that operations are > very slow (delete, select, etc.) even within transactions. [snip] > > CREATE TABLE [Item_attribu

[sqlite] Compound primary key problem

This is a mapping table or descriptor table or whatever you want to call it, between 2 tables (about 120,000 rows). I'm finding that operations are very slow (delete, select, etc.) even within transactions. Foreign keys = ON. I tried a different design with an integer primary key (which in this cas