Haha, now you're taking me too seriously. I didn't mean to sound at all dismissive, Pegasus is generally equal if not superior to other email clients in this respect (and fixing them is generally easy, god forbid I ever have to deal with a corruption in Outlook). However, all clients, Pegasus included, are prone to index corruption from certain events, for example you mentioned when Windows crashes which can be a frequent occurrence for some people.
Another issue I have personally run into is .pmm files that are larger than 2Gb. After the 2Gb barrier Pegasus indexes become 'corrupt' (they start pulling random sections of the .pmm file), likely because the indexes are limited by a 32bit pointer. I asked about this on the mailing lists once and was told it was a problem with Windows and not Pegasus. I should be able to reproduce this in a desktop video if you like.
The jist of my post was simply to point out that regenerating indexes could be faster, when necessary.
"An e-mail message may be 1K in size, or it may be 100MB, and the folder has to cope with this kind of variation efficiently."
I'm not sure I understand. My arguments above are for using a database to store metadata only, not the full body of an email. Storing the full body negates almost all of the benefits of using a database...
BTW, I would not suggest MySQL for a standalone app, SQLite is much more efficient when a full-blown database isn't necessary.
BTW2, maybe you've considered this, but could you not use recursive indexes to create a fast and scalable 'filesystem in a database' structure? These structures are often used in forums, wikis, calendars, etc. It seems like it would be sensible for email too?
<p>Haha, now you're taking me too seriously.&nbsp; I didn't mean to sound at all dismissive, Pegasus is generally equal if not superior to other email clients in this respect (and fixing them is generally easy, god forbid I ever have to deal with a corruption in Outlook).&nbsp; However, all clients, Pegasus included, are prone to index corruption from certain events, for example you mentioned when Windows crashes which can be a frequent occurrence for some people.&nbsp; </p><p>Another issue I have personally run into is .pmm files that are larger than 2Gb.&nbsp; After the 2Gb barrier Pegasus indexes become 'corrupt' (they start pulling random sections of the .pmm file), likely because the indexes are limited by a 32bit pointer.&nbsp; I asked about this on the mailing lists once and was told it was a problem with Windows and not Pegasus.&nbsp; I should be able to reproduce this in a desktop video if you like.
</p><p>The jist of my post was simply to point out that regenerating indexes could be faster, when necessary.</p><p>"An e-mail message may be 1K in size, or it may be 100MB, and the folder has to cope with this kind of variation efficiently."</p><p>I'm not sure I understand.&nbsp; My arguments above are for using a database to store metadata only, not the full body of an email.&nbsp; Storing the full body negates almost all of the benefits of using a database...
</p><p>BTW, I would not suggest MySQL for a standalone app, SQLite is much more efficient when a full-blown database isn't necessary.</p><p>BTW2, maybe you've considered this, but could you not use recursive indexes to create a fast and scalable 'filesystem in a database' structure?&nbsp; These structures are often used in forums, wikis, calendars, etc.&nbsp; It seems like it would be sensible for email too?
</p>