ADO Connection or run Stored Procedures

[wassup]

I am running ASP pages using IIS4 with the data in SQL Server 7

I currently have an asp script to login to the site. The script checks the user name and password are correct using an SQL select statement on the database

Would it be faster to run if I wrote a stored procedure to validate the login?


In general is it quicker to use a Stored Procedure than running ADO with an SQL query?

 

[link9]

Generally, yes it is faster to use stored procedures since the code is already compiled...

For small queries and such, the difference won't be very noticeable, but every little bit helps!


Paul Prewett