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

Reply via email to