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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
