Database suggestions?

[Dan Shafer]

Ken....

Pardon me for jumping in here.

WHile I think it has been generally true that PostgreSQL is actually  
a bit faster than MySQL in apples-to-apples comparisons, the fact is  
that so much of the speed of a relational database is a function of  
how well designed the tables are, how many complex joins are involved  
in the application built on them, and other stuff that isn't really  
native to the DB engines, I'm not sure a fair comparison that is  
universally true can be made.

FWIW, one of the best and fairly objective comparisons I've seen is at:

http://www-css.fnal.gov/dsg/external/freeware/pgsql-vs-mysql.html


On May 13, 2005, at 10:51 PM, Ken Ray wrote:

> On 5/14/05 12:28 AM, "Chipp Walters" <chipp at chipp.com> wrote:
>
>
>> Hi Ken,
>>
>> Here's a couple of things you may want to consider.
>>
>
> Thanks, Chipp... yes, we'll have multiple concurrent users so I  
> guess it's
> MySQL or PostgreSQL. My understanding is that in general, MySQL has  
> better
> performance than PostgreSQL, does that jibe with your take on the  
> two DBs?
>
>
> Ken Ray
> Sons of Thunder Software
> Web site: http://www.sonsothunder.com/
> Email: kray at sonsothunder.com
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Dan Shafer, Co-Chair
RevConWest '05
June 17-18, 2005, Monterey, California
http://www.altuit.com/webs/altuit/RevConWest