Re: MySQL vs. Oracle (not speed)

[Mark Matthews]

Mary Stickney wrote:
> I have been doing speed tests....  the same query ran on MYSQL took 45
> minutes
> on MS-SQL  it took 11 minutes......
> 
> yes you do get what you pay for....

Why not post the queries and the schemas here? My guess is you don't 
have something indexed correctly, or are using a query that gets 
optimized well by MS-SQL Server, but not MySQL.

We all know that SQL is not absolutely portable, and that when you move 
queries from database to database, that there is some work to 
re-optimize them.

There are some queries that just work better on databases other than 
MySQL, but they are very few and far-between.

Without any way to backup your claim, it is hard for anyone here to 
believe that you have done everything possible to make a fair 
comparison. Given your previous comments in this forum, it appears that 
you must be trolling.

	-Mark