I'm a little bit confused about SQLite 3 type system. SQLite 2 was typeless with only exception of INTEGER PRIMARY KEY. I don't get if SQLite 3 are same or not..
I have in my table PRIMARY KEY of INT and TEXT values. I do a lot of operation based on those keys. I can move the TEXT column to another table, where will be that column and INT id, and use that id as composite key in first table - so key will be INT and INT there. Will it be any difference in performance if I will make key INT and INT in SQLite 3?