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 sett开发者_运维百科ings only..and nothing much.. Thanks...
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.
精彩评论