And that limit depends a lot of your computer & system. The realistic limit (of the size of some Sqlite database) is the same as the realistic limit for a data file. What is a realistic max size limit for a SQLite database in real-world use? But I am wondering if I have been underestimating its capabilities. I have only considered SQLite for situations where the database would be tiny dozens of megabytes at most.Īfter reading this article I'm still not convinced to ever consider SQLite for anything that might require hundreds of gigabytes. I'm not a DBA, so this is what I would consider "large" from my direct experience. Of those, at least to my knowledge, none were approaching 140TB. I have also worked indirectly with much larger databases using Oracle, Postgres, or Cassandra. In general, I agree with this, but I was surprised to learn that SQLite's maximum limit was so high! In my experience I have used quite a few SQL Server databases in the size of ~30-100GB. So if you are contemplating databases of this magnitude, you would do well to consider using a client/server database engine that spreads its content across multiple disk files, and perhaps across multiple volumes.
And even if it could handle larger databases, SQLite stores the entire database in a single disk file and many filesystems limit the maximum size of files to something less than this.
According to this article on Appropriate Uses For SQLite it says that, while SQLite is limited to 140 terabytes, a client/server RDBMS may work better:Īn SQLite database is limited in size to 140 terabytes (2 47 bytes, 128 tibibytes).
0 kommentar(er)
