• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
1

Do I need to manaly manage the database connection?

Enthusiast ,
Feb 10, 2010 Feb 10, 2010

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?

TOPICS
Database access

Views

592

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Valorous Hero , Feb 10, 2010 Feb 10, 2010

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

Votes

Translate

Translate
Valorous Hero ,
Feb 10, 2010 Feb 10, 2010

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Enthusiast ,
Feb 10, 2010 Feb 10, 2010

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Valorous Hero ,
Feb 10, 2010 Feb 10, 2010

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Enthusiast ,
Feb 11, 2010 Feb 11, 2010

Copy link to clipboard

Copied

Thanks very much


Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Oct 28, 2024 Oct 28, 2024

Copy link to clipboard

Copied

LATEST
  1.  

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation