MySQL has posted a very interesting comparison on their website. It appears
to be a reasonably fair evaluation. PostgreSQL was faster than MySQL in some
areas and MySQL was faster than PostgreSQL in most areas.
For speed with all of that functionality, I'd be more inclined to look at DB2
rat
Hi!
First of all, if I decide to benchmark MySQL vs. PostgreSQL with my
application, PostgreSQL will probably be faster. That does not mean that
MySQL is "generally" slower or that I *want* it to look slower. That
just means
1) I have no experience in tuning MySQL
2) My application was built wi
> As a minor side issue, we did some _very limited_ testing with MS SQLServer
> 2000 using unicode v ascii queries. Using unicode, queries tended to run at
> about half the speed compare to using ascii.
> This was client server, so it is likely that the increased network traffic
> is to blame, but
> > If maximum speed is critical.
> >
> > It's easy to lose sight of the fact that speed is not the
> > only criterion
> > in choosing a DBMS. Features, stability, security, and so on can be
> > just as important or more so. No single DBMS is going to win all the
> > prizes; the trick is to
same environment and network conditions, mainly, using IPv6
network protocol.
Robson
- Original Message -
From: "Andy Eastham" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2003 2:12 PM
Subject: RE: MySQL vs. PostgreSql -- speed
ubject: Re: MySQL vs. PostgreSQL -- speed test
>
>
> >> >I agree with your opinion in 100%, but in my case I need DBMS with
> >> >features like subselectes/utf-8/stored procedures but the
> >> speed is also
> >> >very important issue.
> >>
>> >I agree with your opinion in 100%, but in my case I need DBMS with
>> >features like subselectes/utf-8/stored procedures but the
>> speed is also
>> >very important issue.
>>
>> You might have to spend money!
>>
>>
>You are saying that there is DBMS with all this features and it is as
>fast as
>> >I agree with your opinion in 100%, but in my case I need DBMS with
>> >features like subselectes/utf-8/stored procedures but the
>> speed is also
>> >very important issue.
>>
>> You might have to spend money!
>>
>>
>You are saying that there is DBMS with all this features and it is as
>fast as
> >I agree with your opinion in 100%, but in my case I need DBMS with
> >features like subselectes/utf-8/stored procedures but the
> speed is also
> >very important issue.
>
> You might have to spend money!
>
>
You are saying that there is DBMS with all this features and it is as
fast as MySQL
>> If maximum speed is critical.
>>
>> It's easy to lose sight of the fact that speed is not the
>> only criterion
>> in choosing a DBMS. Features, stability, security, and so on can be
>> just as important or more so. No single DBMS is going to win all the
>> prizes; the trick is to find th
Very smart your opinion, I agree at all with you.
-Mensaje original-
De: Bruce Feist [mailto:[EMAIL PROTECTED]
Enviado el: Monday, July 14, 2003 5:37 AM
Para: MySQL List
Asunto: Re: MySQL vs. PostgreSQL -- speed test
Marek Lewczuk wrote:
>For everyone who thinks about moving from My
>
> which PostgreSQL version have you testet? If you want compare
> MySQL and
> PostgreSQL, than you have to use InnoDB tables. Tests with
> MyISAM make no
> sense. Out J2EE Application is working woth PostgreSQL 7.3.3
> and MySQL
> 4.0.13 with InnoDB tables (we need transactions and
> refe
> If maximum speed is critical.
>
> It's easy to lose sight of the fact that speed is not the
> only criterion
> in choosing a DBMS. Features, stability, security, and so on can be
> just as important or more so. No single DBMS is going to win all the
> prizes; the trick is to find the one
Marek Lewczuk wrote:
For everyone who thinks about moving from MySQL to PostgreSQL I have a
realy bad news - It's not worth.
That's a bit of an overstatement!
Why, You may ask... A few days ago I
have installed and tested PostgreSQL, becouse I realy need UTF-8 support
and subselects. I thought
Hello group,
For everyone who thinks about moving from MySQL to PostgreSQL I have a
realy bad news - It's not worth. Why, You may ask... A few days ago I
have installed and tested PostgreSQL, becouse I realy need UTF-8 support
and subselects. I thought that PostgreSQL will be as good as MySQL but
a
15 matches
Mail list logo
