On 5/01/2015 11:13 AM, Toby Corkindale wrote:
On 3 January 2015 at 20:50, Andrew McGlashan <andrew.mcglashan@affinityvision.com.au> wrote:
My view is that the sqllite databases are just too big and cumbersome.
I'd almost wager money on it NOT being the fault of SQLite. SQLite is surprisingly effective at handling large databases, and I say that as someone who has worked with such a lot. (It has a lot of other drawbacks, such as poor concurrency and very loose standards support, but that often doesn't matter in embedded use-cases, which is where it's most often found)
What about a 2.6 GB global message store? I found I had real performance issues until I stopped downloading every message to my client machine. The server has all the messages and there are a great many there. Also, I don't do the archive thing any more, my folders are growing continually -- some old messages are removed by some automatic processes via cron on the server (don't need server logs to be kept forever). Messages go to folders via .forward settings on the server and don't usually get moved via Thunderbird. Cheers A.