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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calling an sql2000 stored procedure for one single value from asp.net - NEWBIE 4
ADO.NET Performance Tuning 3
Storing Images and Files in SQL2000 with a project DB as front end. 3
SP help urgent!! 4
XML to DataSet 9
This sure is cornfusing ... connection woes 6
TableAdapter.Update = No Updates 1
Simple way to write DataSet contents to local system. 6

Back
Top