开发者

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

开发者 https://www.devze.com 2023-03-28 15:12 出处:网络
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 ?

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

精彩评论

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

关注公众号