Compiled Joins
Posted: Thu Sep 26, 2002 6:16 pm
Microsoft SQL Server 2000 utilises compiled stored procedures.
A friend of mine is rather good at knowing what is fastest using Microsoft SQL server 2000.
I happen to think that that software is way too expensive and of course... ...can only be used on their OS's.
I use MySQL. Not because I know or believe it's the best, but because others use it and it is well experienced by other Linux users.
I know (the MS-related claims are just what my friend told me):
Stored procedures can be used in Microsoft SQL. They can't be used in MySQL.
Stored procedures are compiled to do the job fast in Microsoft SQL.
MySQL AB is planning to implement stored procedures for MySQL sometime in the future.
I wonder:
Is MySQL significantly slower performing selects and joins than Microsoft SQL's stored procedures?
I am a beginner on this subject.
A friend of mine is rather good at knowing what is fastest using Microsoft SQL server 2000.
I happen to think that that software is way too expensive and of course... ...can only be used on their OS's.
I use MySQL. Not because I know or believe it's the best, but because others use it and it is well experienced by other Linux users.
I know (the MS-related claims are just what my friend told me):
Stored procedures can be used in Microsoft SQL. They can't be used in MySQL.
Stored procedures are compiled to do the job fast in Microsoft SQL.
MySQL AB is planning to implement stored procedures for MySQL sometime in the future.
I wonder:
Is MySQL significantly slower performing selects and joins than Microsoft SQL's stored procedures?
I am a beginner on this subject.