Help in Stored Procedure | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Help in Stored Procedure

Hi, We have SQL Server 2000 Standard Edition.
A query that retrieves 11 thousands rows executes for 36 seconds. If we put the same query in a stored procedure, it takes forever through VB 6.0.
how can i increase the performace of Stored procedure
Any ideas?
Compile the stored procedure, clear the cache and update statistics on involved tables. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Also check for proper indexing why the query is taking so long.
If already have an index then recreate it. or try ITW.
"Forever" is relative. [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br />You need to supply more information in order for us to help. <br />How’s the query look like? <br />How’s the table(s) and indexes look like?<br />How’s the VB code look like?<br /><br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
]]>