l i n u x - u s e r s - g r o u p - o f - d a v i s
L U G O D
 
Next Meeting:
November 4: Social gathering
Next Installfest:
TBD
Latest News:
Oct. 24: LUGOD election season has begun!
Page last updated:
2004 Apr 30 17:10

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



On Thu, Apr 29, 2004 at 11:42:34AM -0700, Michael J Wenk wrote:
> 
> Other than saying a bad query is a bad query, I know of no instance
> where postgres would outperform mysql,

And you wouldn't unless you've done direct comparisons on the same or
similar hardware and/or server loads, worked with varying types and
quantities of data, and done significant query optimization.

> Oh sure, if you have the time to evaluate a ton of software before
> making a decision, then good.

It's not that difficult to configure MySQL or PostgreSQL, particularly
on Linux.  And if you're using a database-independent API (available for
most languages/databases), it's even easier.

> But if you're trying to to a migration quickly(if their license
> agreement with oracle were to end in < a month) then do you really
> have the time?  If it were me I wouldn't.  I also would not have asked
> in the first place if I could spend the time on it. 

If time is of the essence, you also should consider what database you're
coming from and it's level of compatibility with MySQL/PostgreSQL.  If
it's Oracle, then PostgreSQL wins out as others have mentioned.

-David
_______________________________________________
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech



LinkedIn
LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
facebook
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:
Appahost Applications
For a significant contribution towards our projector, and a generous donation to allow us to continue meeting at the Davis Library.