How to reduce time for taken by stored Procedure for inserting a single record?

Posted by padmavathi on Stack Overflow See other posts from Stack Overflow or by padmavathi
Published on 2010-04-23T16:09:34Z Indexed on 2010/04/23 16:13 UTC
Read the original article Hit count: 146

Filed under:

We wrote a stored procedure for selecting a single record from DB at a time. Using the same stored procedure to read 2000 records it takes 4 seconds. Is there any way to optimize it? (like single stored procedure for 2000 records)

Thanks & Regards Padma

© Stack Overflow or respective owner

Related posts about sql-server