Thursday, April 29, 2010

sqlite database size limits

SQLite 应该是算是一个in-process 数据库, 这点不同于server/client database.  正因为如此,  你在Windows上不能使用大于2GB的sqlite数据库,  这是个缺点, 不过, 即使有这个限制, 也已经满足绝大多数应用了.

在下面的文章中, Ivan列出了sqlite的优点和缺点, 并指出了数据库文件大小的限制.
http://www.ivankristianto.com/software-development/visual-studio-net/howto-use-sqlite-ado-net-with-c/943/

Hi Ivan, you mentiona 2Gb limit on the database size, they say 2Tb on the website, are you referring to Windows desktops? I've used Dbs up to 12Gb on Linux without a problem but on my Windows desktop 2Gb appears to be the max.

Hi Murlogue,
yes, i mean on windows machine, because i'm using ADO.NET on windows machine.

No comments: