Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
That depends on the size and the access patterns of your database. –  CL. Jan 14 at 9:38

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.