Aaron Stone wrote:
So... all criticisms of MySQL are exactly on target. But so what? On the
down side, we need to eschew some features and best practices in order to
support MySQL. On the up side, support is actively being added to MySQL
and we can just roll right along with it, incorportating features into
future version of DBMail and raising the bar on our minimum MySQL
requirements as we go.
At this point I know we are not going to drop mysql, but it just
frustrates me that we have to spend 1 second of time working around
limitations. But enough on that topic :-)
It would be really, really nice if someone could do some latest-version
benchmarks between MySQL and PostgreSQL. Bouncing around heresay and
personal preferences only makes me want to support both camps even more
:-P
I couldn't agree more. Some recent updated benchmarks between mysql and
pgsql in general would be interesting, but more interesting to this
mailing list would be some dbmail benchmarks comparing pgsql and mysql.
My guess as to the results would be that mysql is a little faster when
only a few users are connected. I also think that pgsql could be much
faster all around if the code was developed to take advantage of some of
it's features.
Matthew
