sqlite3查询容量大小以及每条数据大小
请问下如何在linux中查询sqlite3容量大小，我用python的话，如何查询插入的一条数据的大小？有什么描述不清楚的话麻烦说一下...
请问下如何在linux中查询sqlite3容量大小，我用python的话，如何查询插入的一条数据的大小？有什么描述不清楚的话麻烦说一下
展开
展开全部
sqlite是文件型的数据库，所有的东西，都在一个文件中，故支持由对应的硬盘文件系统和操作系统来决定
下面是原文解释支持的大小：
Every database consists of one or more "pages". Within a single database, every page is the same size, but different database can have page sizes that are powers of two between 512 and 65536, inclusive. The maximum size of a database file is 2147483646 pages. At the maximum page size of 65536 bytes, this translates into a maximum database size of approximately 1.4e+14 bytes (140 terabytes, or 128 tebibytes, or 140,000 gigabytes or 128,000 gibibytes).
下面是原文解释支持的大小：
Every database consists of one or more "pages". Within a single database, every page is the same size, but different database can have page sizes that are powers of two between 512 and 65536, inclusive. The maximum size of a database file is 2147483646 pages. At the maximum page size of 65536 bytes, this translates into a maximum database size of approximately 1.4e+14 bytes (140 terabytes, or 128 tebibytes, or 140,000 gigabytes or 128,000 gibibytes).
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
|
广告 您可能关注的内容 |
