Gavin Cooney wrote:
The application.log file contains quite a few of the following entries:
The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is:
/some path... /online_mcq/some page name.cfm
The site is running on a dedicated Linux server with a gig and a half of ram. The DB runs on MySQL. The pages that are getting this error have nothing too special about them, and they do not have a timeout set on the CFQUERY tags.
Basically the app is bottlenecking at the DB. You need to improve database performance.
Can anyone advise me on how to prevent this?
Look at creating appropriate indices in the database. Optimise the queries themselves. Cache the queries using ColdFusion query caching.
If you opt to use query caching you may want to make sure your JVM memory settings and query cache settings reflect (in terms of size and frequency) the sort of queries you are caching.
Currently I have the following cf admin settings: Limit simultaneous requests to 20
Generally this setting should be 3-5 threads per CPU. If you have an external app (eg the database) that is slow you might increase the number of threads. Generally it is better to sort out the external app and keep the threads low.
Timeout Requests after ( seconds ) 180
This is very bad. Expecially on highly-trafficked sites. Unless you expect your users to wait 180 secs for a page response this should be around 35secs with specific pages having longer timeouts specified.
and in the Advanced settings for the datasource: Limit to 20 connections. Maintain Connections with 20 minute timeout.
Don't timeout the connections -- establishing the db connection is costly and nothing but CF appears to be using the box. The limit is not that relevant given you have only 20 CF threads.
If anyone could give me some tips, I would be very grateful
Listen to the following presentation -- it might give you some pointers on how to set up the CF box more efficiently:
http://blog.daemon.com.au/archives/000158.html
Best regards,
-- geoff http://www.daemon.com.au/ p. 02 9380 4162
PS. Daemon specialises in high-end CF consulting and offers formal code reviews, performance analysis and testing, database optimisation and other troubleshooting services, feel free to give us a call :)
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
