> So no, you won't gain anything by trying to avoid this column - > it is always there whether you declare it or not.
But I found that inserts were faster if I didn't create the table with INTEGER PRIMARY KEY, so it looked I gained there, although I understand I might lose out somewhere else. RBS -----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: 11 July 2007 20:18 To: SQLite Subject: [sqlite] Re: How to store 128 bit values RB Smissaert <[EMAIL PROTECTED]> wrote: > It seems if you do inserts on a table it is faster if you have no > INTEGER > PRIMARY KEY on that table You _always_ have an INTEGER PRIMARY KEY on every table. It's part of SQLite storage mechanism. If you don't explicitly declare one, it's still there under the name ROWID or OID (and a few other synonyms). By explicitly declaring it, you simply give the same column yet another name. So no, you won't gain anything by trying to avoid this column - it is always there whether you declare it or not. Igor Tandetnik ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------