Re: MySQL vs. Oracle (not speed) - not part of the rant, but real information

[David Lloyd]

Adam,

[ mysql, query ]

> However, you can do it manually (I think) by playing around with both
> the order of the where clause and the order of the join clause

Yes.

> Also, MySQL has a really wimpy default configuration (I can't figure out
> why).  Here is my /etc/my.cnf (I don't know what the equivalent is on
> windows)

Most likely to cater for people running MySQL on servers without a lot
of memory. Fancy having a key-buffer of 256M if you only had 128M of
real memory...

DSL

(ps: how the world has this discussion gone from Oracl to Micorosft SQL
Server...lol)