List: | General Discussion | « Previous MessageNext Message » | |
From: | Mark Matthews | Date: | August 16 2002 2:14pm |
Subject: | Re: MySQL vs. Oracle (not speed) | ||
View as plain text |
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