l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2004 Apr 28 18:44

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
RE: [vox-tech] oracle -> MySQL conversion
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [vox-tech] oracle -> MySQL conversion

--- matthewlange <matthewlange@hotmail.com> wrote:
> Dylan, Definitely Postgres.
> You may not need the functionality now, but you may want it in the
> future.

My $0.02:

Unless you really need the advanced features of Postgres, MySQL should do
everything you need it to do, and be a little more lightweight.  I am not
saying that you should definitely go one way or another, just that MySQL might
perform better for your application.

I think we decided on Postgres because MySQL didn't have transactions at the
time, and that was one feature we needed.

Given the size (+50GB) and if you don't need the features of Postgres, I
wouldn't completely write off MySQL, b/c in it's simplicity lies it's beauty.

We only let our postgres dbs to a certain size (more than a million rows in our
schema), b/c they really slow down (mind you, we use PC's off the shelf).  That
would be my worry for you in this case:  you get all your data imported and all
your queries working and... it's slower than you would like it to be.

Don't interpret this as knocking Postgres, I use it and think it's great.  It's
just not a mature codebase the way that Oracle and other RDBMS's are... and
anyone who says that Postgres is a fast RDBMS is fooling themselves.  And since
you're coming from Oracle, your operation might be attuned to it's performance.

The guys over at GreatBridge have made really strong advances, but the
competition is stiff.  And MySQL has made some really strong advances as well. 

Keep a laser beam focus on the features that _you_ need and the right choice
will become self-evident.

--that was quite a rant,


EDUCATION, n. That which discloses to the wise and disguises from the
foolish their lack of understanding.

Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
O'Reilly and Associates
For numerous book donations.