Performance issue

[Ray]

Hi all,

There is a stored proc that has an input parameter (used
in where clause) and returns hundreds (sometimes
thousands) of records. Select statement inside the stored
proc consists of ten joined tables. The performance
(speed) is an important issue here, as the result is sent
back to Web clients. I'm looking for a better way to
implement the process and for the moment improving select
statement is not my concern. This is a .NET application
and I'm open to any suggestion even employing XML support
in SQL Server.
Thanks in advance,

Ray

 

[Marina]

For improving stored procedure performance, I suggest you turn to the sql
server programming group, as this does not directly relate to ado.net, since
you are looking to increase performance on the database side.