Performance issue

  • Thread starter Thread starter Ray
  • Start date Start date
R

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
 
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.
 
Back
Top