471,078 Members | 781 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,078 software developers and data experts.

Need Help Closing Database connections

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.
Aug 16 '08 #1
1 2925
acoder
16,027 Expert Mod 8TB
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?
Aug 17 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by dustin lee | last post: by
2 posts views Thread by Lin Ma | last post: by
1 post views Thread by C Sharp beginner | last post: by
7 posts views Thread by darrel | last post: by
7 posts views Thread by Martien van Wanrooij | last post: by
13 posts views Thread by PinkBishop | last post: by
5 posts views Thread by zacks | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.