Re: [sqlite] When is db size an issue?

2017-10-02 Thread Roberts, Barry (FINTL)
We have logged live data into databases that are over 200GB without any issues. I don't think SQLite will be the issue itself, as it is merely limited by the file system. The more likely issue is when you need to transfer or backup the file, it can get unwieldy if it is too large. Kind Regards,

Re: [sqlite] When is db size an issue?

2017-10-01 Thread Eduardo Morras
On Wed, 27 Sep 2017 08:41:25 -0400 "Jason T. Slack-Moehrle" wrote: > Hello All, > > Off and on for the last few years I have been writing an e-mail > client to scratch a personal itch. I store the mail in SQLite and > attachments on the file system. However, I recently brought in all of > my mai

Re: [sqlite] When is db size an issue?

2017-09-27 Thread Simon Slavin
On 27 Sep 2017, at 1:41pm, Jason T. Slack-Moehrle 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: Sorry, but your email

Re: [sqlite] When is db size an issue?

2017-09-27 Thread David Raymond
2017 8:45 AM To: SQLite mailing list Subject: Re: [sqlite] When is db size an issue? On 9/26/17, Jason T. Slack-Moehrle wrote: > Hello All, > > Off and on for the last few years I have been writing an e-mail client to > scratch a personal itch. I store the mail in SQLite and attachment

Re: [sqlite] When is db size an issue?

2017-09-27 Thread Richard Hipp
On 9/26/17, Jason T. Slack-Moehrle wrote: > Hello All, > > Off and on for the last few years I have been writing an e-mail client to > scratch a personal itch. I store the mail in SQLite and attachments on the > file system. However, I recently brought in all of my mail for the last 15 > years fro

[sqlite] When is db size an issue?

2017-09-27 Thread Jason T. Slack-Moehrle
Hello All, Off and on for the last few years I have been writing an e-mail client to scratch a personal itch. I store the mail in SQLite and attachments on the file system. However, I recently brought in all of my mail for the last 15 years from mbox format. Now, my database size is over 10gb. I'm

[sqlite] When is db size an issue?

2017-09-27 Thread Jason T. Slack-Moehrle
Hello All, Off and on for the last few years I have been writing an e-mail client to scratch a personal itch. I store the mail in SQLite and attachments on the file system. However, I recently brought in all of my mail for the last 15 years from mbox format. Now, my database size is over 10gb. I'm