开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜