MySQL vs PostgreSQL formerly --> Re: [PLUG] Storing XML docs in SQL database on Linux?

[Alex Daniloff]

=20=20=20=20?= <32864.192.168.1.252.1054276345.squirrel at webmail.tearitalldown.com>
MIME-Version: 1.0
Message-Id: <03053006181000.06544 at gate>
Content-Transfer-Encoding: 8bit

If you want to pay big $$$, sure, go with Oracle.
The question is how you would justify Oracle cost and
its licenses cost to your management if you can get 
nearly the same for free?

On Thursday 29 May 2003 11:32 pm, you wrote:
> Oracle.
>
> >
> > Robby,
> > Let me respectfully disagree with you on PostgreSQL vs MySQL issues.
> > I've worked with both databases and tested them throughfully in our
> > engineering environment over two year period.
> > Finally our dept. decided to go with MySQL for all our engineering
> > applications, data collection and statistical analysis.
> > MySQL with InnoDB tables (which are ACID compliant) beats PostgreSQL
> > in terms of speed, number of simultaneous connections, security and
> > scalability. All these extended features in PostgreSQL as subqueries,
> > stored
> > procedures and such are easily implementable on the API level in Perl.
> > To pull data of 1,200.000 rows Mysql spends just about 3.5 seconds,
> > PostgreSQL spends over 20 seconds on the same hardware.
> > We have no problem with over 250 simultaneous client connections to MySQL
> > server and  we had problems with PostgreSQL when number of simultaneous
> > connections reached just 80 on the same hardware.
> > MySQL takes a full benefit of RAID0, PostgreSQL doesn't have such an
> > optimization.
> >
> > Regards.
> > Alex
> >
> > On Thursday 29 May 2003 03:46 pm, you wrote:
> >> Alex,
> >> I've been a fan of MySQL for a few years, but now I think PostgresSQL is
> >> much more efficient for business use, not to mention it has more
> >> features
> >> that MySQL doesn't...because they are mainly interested in speed.
> >>
> >> You're not going to loose much speed pulling back a largeobject from
> >> psql
> >> as you would pulling back a blob from mysql.
> >>
> >> -Robby
> >
> > _______________________________________________
> > PLUG mailing list
> > PLUG at lists.pdxlinux.org
> > http://lists.pdxlinux.org/mailman/listinfo/plug
>
> _______________________________________________
> PLUG mailing list
> PLUG at lists.pdxlinux.org
> http://lists.pdxlinux.org/mailman/listinfo/plug