On 10 Feb 2010, at 7:51pm, Ibrahim A wrote: > An "INTEGER PRIMARY KEY" is at least twice as fast as another type of > PRIMARY KEY, > the reason is based on the implementation of the engine. An integer > primary key substitutes the rowid column of a table.
But that's true only if you're running a SELECT which actually uses that column and only that column to do the searching. Which is why I asked that question earlier on in this thread. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users