devxlogo

Using Stored Procedures Boosts Performance in ASP

Using Stored Procedures Boosts Performance in ASP

Active Server Pages that utilize databases like SQL Server are no different than conventional programs in that they will experience a performance boost when you use stored procedures instead of ad-hoc queries. SQL, as always, optimizes the query of stored procedures, giving you that performance boost that is even more relevant as you have hundreds or thousands of users hitting your site.

devx-admin

Share the Post: