Using Stored Procedures over Direct SQL ...

Following are the performance numbers obtained by using Stored Procedures and Direct SQL to fetch 20000 rows from a database table.

 

Stored Procedures

 

DataAdapter	DataReader
625 ms	15 ms
516 ms	0 ms
516 ms	0 ms
516 ms	0ms

Direct SQL

DataAdapter	DataReader
547 ms	16 ms
578 ms	0 ms
562 ms	16 ms
844 ms	16ms

After first time use stored procedures are observed to give consistent and better performance.

 

 

Thanks & Regards,

Arun Manglick

SMTS || Microsoft Technology Practice || Bridgestone - Tyre Link || Persistent Systems || 3023-6258

 

DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt. Ltd. does not accept any liability for virus infected mails.