Inspiring

Answered

Do I need to manaly manage the database connection?

5 replies
804 views
Translate

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 is closed to new replies. Start a new post to keep the conversation going.

-__cfSearching__-Correct answer

Inspiring

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

Participant

Translate

-__cfSearching__-

Inspiring

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

Translate

Inspiring

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

Translate

-__cfSearching__-Correct answer

Inspiring

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

Translate