3 ms·
> 7. SQL functions rarely perform well. So SQL Server is not good at SQL. How does it compare performance wise between alternative SQL DBs?
by exclusiv 10y ago
> 7. SQL functions rarely perform well.
So SQL Server is not good at SQL.
How does it compare performance wise between alternative SQL DBs?
- ZenoArrow 10y ago>"So SQL Server is not good at SQL." That's not what was implied. SQL functions are snippets of SQL you wrap in a function to use in a larger query. The issue being suggested is that SQL Server will go into single-threaded execution when SQL functions are used. However, you can use stored procedures for the same purpose as functions without incurring the same performance penalty, so the advice was a warning about a specific SQL Server feature rather than the platform as a whole.
- exclusiv 10y agoMy mistake. I realize now the author is talking about user defined SQL functions and not app layer SQL functions for composing SQL. Thanks for the clarification.