Copy link to clipboard
Copied
I'm having issues with a stored procedure that returns data to CF. The sp takes around 20 seconds to return the data (big sp) to CF but the database connection is left idle after the sp finshes and the data is passed to CF, as we can see from MS SQK management studio.
Do I need to manualy manage the database connection? I thought the CF data source would manage all this?
Yes. I believe it is a checkbox option under each datasource. Something like "Maintain connections .."
Copy link to clipboard
Copied
Are you using connection pooling? If so, CF will maintain a pool of open database connections.
Copy link to clipboard
Copied
I'm not sure, can I find that setting in cf admin?
Copy link to clipboard
Copied
Yes. I believe it is a checkbox option under each datasource. Something like "Maintain connections .."
Copy link to clipboard
Copied
Thanks very much
Copy link to clipboard
Copied