Re: ms-sql vs oracle on NT or UNIX?

"steven jones" <steven_jones_at_snellville.net> writes:

> We have found that Oracle/Unix provides the best performance ...
> Oracle/NT next ... and MSS/NT has proven to be a real dog.
> A new version of MSS is on the horizon and may offer better performance ...
> but for now we are finding the performance to be very bad.

I'd agree with that. mysql (unix at least) is much faster than msql -- i'd hazard that once it gets foreign keys and subqueries it will totally annhililate MSS/NT, but, it won't be bundled with black office....

Heck, i've seen it (mysql) smoke oracle WGS with certain types of databases (admittedly, running w/o transactions,rollbacks,etc is an unfair speed advantage), and don't ask what it does to msql :)

pros/cons of mysql vs. oracle:

msql : mostly the same as mysql (below), just somewhat slower and

        has fewer builtin goodies.

mysql : great for setups where you don't need transactions and you

	wont be performing subqueries ('cause they aren't supported yet).
	the sql syntax is a snap compared to most commercial implentations,
	however be warned that the default action is

	StRiNg1 = string1 in mysql. not so in oracle.

	mysqldump drops a sql representation of your database (ooooh ahhhh)
	which i've found to be really neat for replication
	(mysqldump -h host1 db | mysql -h host2 -f db)

	if you've pretty much a single table database with a few lookups,
	sane keys and whatnot, this sucker rocks and rolls.

oracle: great if you want support, subqueries, outer joins, full programming,
	foreign keys, triggers, yadidy-yada, outlandish indexing, etc. 

as for mysql vs. msql, don't waste your time with msql if you can use mysql. mysql is fully compatible with the latter and it eats msql's shorts (http://www.tcx.se/benchmark.html)

nutshell: if you database is relatively simple and you don't mind

	not having subqueries, then give mysql a shot. If you are
	planning on importing that monster database snarling in the corner
	with tables everywhere and you MUST have data integrity
	across your tables, then you want oracle.

• craig

  ---

Craig I. Hagan     "It's a small world, but I wouldn't want to back it up"
hagan(at)cih.com        "True hackers don't die, their ttl expires"
  	"It takes a village to raise an idiot, but an idiot can raze a village"

	Stop the spread of spam, use a sendmail condom!
	     http://www.cih.com/~hagan/smtpd-hacks

                       In Bandwidth we trust