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] -----------------------------------------------------------------------------
