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.
Thursday, April 29, 2010
sqlite database size limits
Posted by WadeLiu at 11:37 PM
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment