On 27 Sep 2017, at 1:41pm, Jason T. Slack-Moehrle <[email protected]> wrote:
> However, does anyone have any thoughts about the size? Should I be > concerned? Is there a theoretical limit I should keep in the back of my > mind? Not, theoretical, practical: <https://sqlite.org/limits.html> Sorry, but your email database will be limited to 140 Terabytes in size, and if your users want to keep more than half a quadrillion messages every day for a hundred years they’re going to have to archive the older ones. Such a shame. I used to have a 43Gb database, most of it being one long thing table of hundreds of billions of rows. Ran without problems and was extremely fast to search. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

