*** 14,17 **** --- 14,21 ---- <H2>Order your tables properly in your where clause</H2> Place the tables where you can eliminate the most rows from using a where clause (preferably on an indexed column) first, in order to limit the number of join operations required. + <H2>INDEXES on INTEGER PRIMARY KEY columns (Don't do it)</H2> + When you create a colunm with INTEGER PRIMARY KEY SQLite uses this column as the key(index to) for the table structure. This is a hidden index (as it isn't displayed in SQLite_Master table) on this column. Adding another index on the column is not needed and will never be used. In addition is will slow INSERT, DELETE and UPDATE operations down. + + </html>
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|