Problem with procedures in MSSQL
| From: | Hugo Alexandre Almeida Soares Dias | Date: | Fri, 20 Apr 2001 17:21:58 +0000 |
| Subject: | Problem with procedures in MSSQL | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-6929@lists.php.net to get a copy of this message | ||
I created a stored procedure in MSSQL like this:
CREATE PROCEDURE destaques_relacionados @codigo_doc int, @relacao
varchar(20) AS
SELECT TOP 5 DN.cod, DN.titulo
FROM dbo.Keywords_associacoes KA INNER JOIN
dbo.Destaques_noticias DN ON KA.documento = DN.cod
INNER JOIN
dbo.Associacoes A ON KA.associacao = A.cod
WHERE (KA.keyword IN
(SELECT keyword
FROM keywords_associacoes ka2,
associacoes a2
WHERE ka2.documento = @codigo_doc AND
ka2.associacao = a2.cod AND a2.tabela = @relacao)) AND (KA.documento !=
@codigo_doc) AND (A.tabela = 'Destaques')
GROUP BY KA.documento, DN.data, DN.cod, DN.titulo
ORDER BY COUNT(KA.keyword) DESC, DN.data DESC
GO
This procedure when i execute it in the SQL Analyzer runs instantaniously,
but in PHP hangs till timeout.
can anyone tell me what i must do to solve my problem?
Hugo Alexandre Dias
Eng. Sistemas Informática
anikin@ip.pt