Re: [mv] MySQL vs PostgreSQL

[Mark Stosberg <mark@summersault.com>]

******    message to minivend-users from Mark Stosberg <mark@summersault.com>     ******

Mike Heins wrote:
> 
> I personally like the idea of using Postgres or Oracle for the
> orderline/transaction/userdb tables, and MySQL for everything else.
> This gives you the speed for the frequently accessed things, and
> the referential integrity for the things which can use them.

That sounds good as far as picking the best of easy database package,
but the idea of maintaining two databases for a single project sounds
like a big headache to me. You'd have to know the particularities of
each to handle crashes and backups, etc.

I use Postgres for dozens of projects of varying sizes, and have always
been happy with the performance. I think when MySQL really pulls ahead
on performance in a noticeable way is when you have a huge amount of
hits, maybe 100,000 hits a day (I'm saying that without having tested
it). 
I think in a lot of cases Postgres provides great performance in
addition to it's nice additional features.

  -mark
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list