Re: CFqueryParam Coldfusion 11

2014-11-28 Thread Dave Watts
Does anyone know of any supposed issues with CF 11 and cfqueryparam ? I had a few of them in a query. One by one I removed them to see if I could get the query working and then, adding them in. All but one work. Any ideas? You need to provide more information. Did the query work with CF

Re: CFqueryParam Coldfusion 11

2014-11-28 Thread Don
The errors getting back are all The request has exceeded the allowable time limit Tag Seems that the whole server eventually crashes/slows to crawl, even though other websites on that same server are fine. CF Version 11 / SQL Server Express Looking at the JVM free memory, it always seems to

Re: CFqueryParam Coldfusion 11

2014-11-28 Thread John M Bliss
Does the line number on that error indicate that the query is what's timing out? On Fri, Nov 28, 2014 at 11:46 AM, Don danfar...@hotmail.com wrote: The errors getting back are all The request has exceeded the allowable time limit Tag Seems that the whole server eventually crashes/slows to

Re: CFqueryParam Coldfusion 11

2014-11-28 Thread Dave Watts
The errors getting back are all The request has exceeded the allowable time limit Tag What's happening on the database server? Have you stopped and restarted the database server? Have you disabled and reenabled the Maintain Connections option in your database driver? Dave Watts, CTO, Fig

Re: how to diagnose a potential bottleneck

2014-11-28 Thread Don
I suggest installing fusionReactor and monitoring your local cfserver. Run some performance/load testing on the app and see what happens, it should you what pages are having issues Run cfdebugger on those pages Russ, on our host installing this is not possible right now. is there anything else

Re: how to diagnose a potential bottleneck

2014-11-28 Thread .jonah
Just using the builtin server monitoring in CF Enterprise was pretty helpful to me to find the slow/hung requests. After optimizing those things got better but ultimately moving from CF9 to CF11 on a new box solved our crashing issues. On 11/28/14, 10:01 AM, Don wrote: I suggest installing

Re: how to diagnose a potential bottleneck

2014-11-28 Thread Byron Mann
Sounds like you are on a shared server if the host cannot, install something to your liking. This could be a case of another site on the server bringing it down and not your site. Byron Mann Lead Engineer Architect HostMySite.com

Re: how to diagnose a potential bottleneck

2014-11-28 Thread Russ Michaels
You don't do it on the host, you do it locally On Fri, Nov 28, 2014 at 18:01 PM, Don danfar...@hotmail.com wrote: I suggest installing fusionReactor and monitoring your local cfserver. Run some performance/load testing on the app and see what happens, it should you what pages are having