Inspiring

Answered

Do I need to manaly manage the database connection?

Forum|Forum|15 years ago
February 10, 2010
2 replies
779 views

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?

Database access

This topic has been closed for replies.

Correct answer -__cfSearching__-

Yes. I believe it is a checkbox option under each datasource. Something like "Maintain connections .."

Participant

-__cfSearching__-

Inspiring

Are you using connection pooling? If so, CF will maintain a pool of open database connections.

Inspiring

I'm not sure, can I find that setting in cf admin?

-__cfSearching__-Correct answer

Inspiring

Yes. I believe it is a checkbox option under each datasource. Something like "Maintain connections .."