Problemas com TimeOut na cfprocedure

[AzevedoEdison]

Estou rodando uma procedure meio lenta que gera um relatório, ou seja ela retorna vários valores, e está estourando um erro de timeout:

The request has exceeded the allowable time limit Tag: CFSTOREDPROC

Já tentei utilizar <cfsetting RequestTimeOut='100000' > na página mas infelizmente não funcionou.

Como estou utilizando a versão 7 do Coldfusion a tag timeout ainda não funciona para a cfstoredproc. Acredito que isso só funciona na versão 10.

Minha pergunta é, o que fazer??? Além de tentar otimizar a procedure, tenho mais alguma opção/alternativa/solução ?

[p_sim]

Question translated from Portuguese to English using Google Translate:

I'm running a bit slow procedure that generates a report, ie it returns multiple values​​, and is bursting a timeout error:

The request has exceeded the allowable limit Tag team: CFSTOREDPROC

I've tried using <cfsetting RequestTimeOut='100000'> page but unfortunately did not work.

Since I'm using version 7 of the ColdFusion tag timeout still does not work for CFSTOREDPROC. I believe this only works in version 10.

My question is, what to do?? Besides trying to optimize the procedure, I have some more option / alternative / solution?

-----------------------------------------------------------------------------------------------

I would see how long does it take to run the stored proc. in database. Then, determine how big the data returned from the stored proc. Keep in mind, the data will need to travel across network if your ColdFusion server is separate from database server. From there, you could determine how long you should set the timeout value.

[Himansu Sekhar Khuntia]

Hi AzevedoEdison,

I am not sure if you had any work around for this or not. But in ColdFusion 10 onwards timeout attribute has been introduced in CFSTOREDPROC tag and it takes the timeout value in seconds.

Thanks