CODEWITHSUNDEEP
sqlite
VMN
VMN

Reputation: 181

What is the size of the data that I can maintain in SQLite in a desktop application?

If have you use SQLite to develop a Desktop application, will there be any limitation to the size of data that I can store into it ? Will there be any performance issues ? As I read somewhere that browers use it to store settings only..and nothing much.. Thanks...

Upvotes: 1

Views: 160

Answers (1)

Mike W.
Mike W.

Reputation: 1375

From Implementation Limits For SQLite:

The largest possible setting for SQLITE_MAX_PAGE_COUNT is 2147483646. When used with the maximum page size of 65536, this gives a maximum SQLite database size of about 14 terabytes.

The max file size could be smaller depending on your filesystem. As for performance, that depends more on your schema, queries, indices, type of data being stored, etc.

Upvotes: 1

Related Questions