This is one crazy contest that current FOSS solutions can compete in the first yard, but won't go beyond the second to the whole nine yards! Current open source databases have simplistic algorithms for indexing - it's not even worth mentioning once you need more complicated indexes (e.g. partial indexing on dates, among other things). Multi-dimensional queries are also a pain with either MySQL and Postgresql - doing OLAP with these isn't for the faint of heart.
Simple enough - if your needs are simple, or esoteric enough that Oracle won't fit (e.g. MPP) - go with Postgresql, MySQL or the other FOSS databases, as these offer the best bang in the buck for those configurations. The moment you need support for stuff like OLAP, OLTP or multiple standards compliance, then get Oracle, as it will offer the best bang in the buck for those configurations. On Mon, Mar 30, 2009 at 7:05 PM, Ambrosio Berdijo <[email protected]> wrote: > I prefer to see benchmarks....doesn't everybody :-) > > And it would be great if we can have PostgreSQL along. > > How about we let the Open-Source team define the tests and the ORACLE > team define the data to be used.. Or each team show-off what their system > can do best. But everything must run on the same hardware. > Maybe we can get sponsors that can lend us servers (maybe IBM, DELL > or SUN(!!) demo units). > > In any case, it would be great learning experience. I will agree that > ORACLE is the best for enterprise. But at what point does one stop using > Open-Source > and say to management, "hey we need to have an enterprise DB like ORACLE > and here are the reasons". Yes, Please do educate us and tell us the "vast > depth" of ORACLE features.....but don't forget to mention the ORACLE pricing > model..... > > > --- On Sat, 3/28/09, Orlando Andico <[email protected]> wrote: > > From: Orlando Andico <[email protected]> > Subject: Re: [plug] Met a KDE Developer last night > To: "Philippine Linux Users' Group (PLUG) Technical Discussion List" > <[email protected]> > Date: Saturday, March 28, 2009, 10:32 AM > > On Sat, Mar 28, 2009 at 2:27 AM, Ambrosio Berdijo <[email protected]> > wrote: > .. >> P.S. >> Let's have a MySQL vs.ORACLE showdown in the next conf... > > Is it even worth the effort, except to see a fight? :-) > > People who use either DB know what their needs are. > > I'd be willing to give an intro on Oracle DB 11g plus the new > developer features we have and support for Open tools such as PHP and > Perl, however. > > It's been my experience that most Open Source oriented developers (me > included!!!) have no idea of the vast depth of features in Oracle DB. > > > > -- > Orlando Andico > +63.2.976.8659 | +63.920.903.0335 > _________________________________________________ > Philippine Linux Users' Group (PLUG) Mailing List > http://lists.linux.org.ph/mailman/listinfo/plug > Searchable Archives: http://archives.free.net.ph > > > _________________________________________________ > Philippine Linux Users' Group (PLUG) Mailing List > http://lists.linux.org.ph/mailman/listinfo/plug > Searchable Archives: http://archives.free.net.ph > _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
