Connecting Tech Pros Worldwide Help | Site Map

Need Help Closing Database connections

Newbie
 
Join Date: Aug 2008
Posts: 1
#1: Aug 16 '08
I am running a website at GoDaddy where I have their least expensive plan that supports Linux/ColdFusion/mySQL. Apparently this plan supports a small number of active database connections (50). I wrote my ColdFusion code in Dreamweaver and just assumed it would take care of issues like this, but I guess it doesn't.

If I have a few windows open on the same machine and just keep hitting the site, I can easily cause it to 'crash' to the point where it says there is a JRUN Server error. Godaddy support says this is happening because I have too many open database connections and that I need to adjust my code so that the database connections are closed.

I don't know how to do that or what the best practices are about when to, and when not to, do it. Any advice would be greatly appreciated.
acoder's Avatar
Site Moderator
 
Join Date: Nov 2006
Location: UK
Posts: 14,581
#2: Aug 17 '08

re: Need Help Closing Database connections


Do they provide an interface to the CF Administrator? You can change the settings there? Also how many queries do you have on a page?
Reply