How to reduce time for taken by stored Procedure for inserting a single record?
- by padmavathi
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