using SQL2000 and SP to improofe performance.

  • Thread starter Thread starter Manfred Steyer
  • Start date Start date
M

Manfred Steyer

Hi!

What would be better concerning performance:

1. querying Data from an MS SQL2000-DB using an SELECT-Command like "Select
* from xyz where id = 222" using a DataAdapter and a DataSet or

2. querying Data from an MS SQL2000-DB using an Stored Procedure like
"mySP(222)"
using a DataAdapter and a DataSet

I'm sure, that in former days the first one was the faster one. But as
SQL2000 has some kind
of query cache ...

Best Regards,
Manfred Steyer
 
2. Should be faster since the SP has be compiled and SQL
does not need to create an execution plan. Whereas in
1., SQL needs to create an execution plan.
 
Back
Top