[sqlite] Performance Question

[Slater, Chad]

Hello,

Consider the following lookup table definition:

CREATE TABLE foobar (
    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    table1_id INTEGER NOT NULL REFERENCES table1,
    table2_id INTEGER NOT NULL REFERENCES table2
);

The id primary key column is not necessary for anything in my
application. But I've heard that some database implementations recommend
the primary key for performance reasons. Is this true for sqlite?


TIA,


Chad

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------