Jocke wrote:
I posted a message earlier, but to the wrong mailinglist, where I said
that I would be happy to help with optimisations regarding the database.
At work I do a lot of optimization where I reduce the number of
queries, and speed up queries that are to slow.
I would be happy to help in any way I can if someone could point me in
a direction where I should start.
I almost solely work with MySQL at work.
I think there is probably lots of room for optimization and as noted by
someone else earlier, I think reducing the number of individual queries
should be some nice low hanging fruit. My only other comment is that we
need to continue to keep things as database independent as possible.
Any optimization you make needs to at least work on PostgreSQL with
hurting it's performance, and visa-versa.
While dbmail is much better than flat file email storage in many ways, I
think it still gets outperformed in some operations. There is
discussion of this in the archives if you can find it. I find it
frustrating that the email archives for this project are not
searchable. I would think that would be a natural for a database email
storage system. BTW, I would be interested in working on resolving
this, I know PostgreSQL has an FTI engine that could is used by the
PostgreSQL project to search their archives.
Matthew
