Hi All,
I’ve been working with an Application Server for a year with coldfusion 6.1.0.63958 installed.
Some users have been experiencing performance issues and I found out that this issue is caused by a store procedure called from a cfstoreproc tab.
The issue does not happen every day but when it happens the store procedure executed from SQL Server Analyzer takes 2 seconds. When is executed from the coldfusion interface takes 40 seconds. I put the cfstoredproc in a separate file to isolate the problem but even if I execute this cfstoredproc from a blank cfc page takes ages.
We are going to upgrade the coldfusion server version to 6,1,0,83762
Next week but I haven’t seen any fix about that in the release notes.
I call to another 5 store procedures from the same screen and they work fine. Do you know if there is any limit of recordset or if there is any issue with this coldfusion version??
The query uses a “SELECT TOP 1” but as I said is very quick from the database (1-2 seconds).
Any idea, please?
Thanks a lot!!!
I’ve been working with an Application Server for a year with coldfusion 6.1.0.63958 installed.
Some users have been experiencing performance issues and I found out that this issue is caused by a store procedure called from a cfstoreproc tab.
The issue does not happen every day but when it happens the store procedure executed from SQL Server Analyzer takes 2 seconds. When is executed from the coldfusion interface takes 40 seconds. I put the cfstoredproc in a separate file to isolate the problem but even if I execute this cfstoredproc from a blank cfc page takes ages.
We are going to upgrade the coldfusion server version to 6,1,0,83762
Next week but I haven’t seen any fix about that in the release notes.
I call to another 5 store procedures from the same screen and they work fine. Do you know if there is any limit of recordset or if there is any issue with this coldfusion version??
The query uses a “SELECT TOP 1” but as I said is very quick from the database (1-2 seconds).
Any idea, please?
Thanks a lot!!!