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.
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.
Comment