3 ms·
Opt for the stored procedure whenever you can. Your database will be able to yield much better performance - even if you have average SQL skills. If you have a
by taylodl 5y ago
Opt for the stored procedure whenever you can. Your database will be able to yield much better performance - even if you have average SQL skills. If you have a SQL query giving you performance fits then you can bring in someone with greater SQL expertise to optimize it for you and your code isn't impacted.