ColdFusion

Query Time

Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2007

Posts: 34

Reputation: chicago1985 is an unknown quantity at this point

Solved Threads: 0

chicago1985 chicago1985 is offline

Offline

Light Poster

Query Time

May 18th, 2008

r CF MX 7 the CF admin setting for database queries timeout is set at 100. Because of this some of my queries timeout and give me back a timeout message.

I am trying to overwrite it in my cfquery working with Oracle 9i:

Help with Code Tags

(Toggle Plain Text)

<cfquery datasource="cityOra" timeout="300" name="queryOne">
select * from mainTable
</cfquery>

It still gives me timeout message after 100 seconds no matter what I have in the cfquery timeout. Please advise why this is not overriding the CF Admin and timeout or how I can override it?

Last edited by chicago1985; May 18th, 2008 at 8:40 am.

•

Join Date: Feb 2008

Posts: 72

Reputation: cmhampton is an unknown quantity at this point

Solved Threads: 10

cmhampton

Offline

Junior Poster in Training

Re: Query Time

May 22nd, 2008

I think first of all you need to figure out why your queries are taking longer than 100 seconds. Unless your running a migration script, your queries should be much faster.

Is this the query you were trying to run, or are you using that as an example? If so, there's absolutely no good reason a simple select query should take that long.

Changing the timeout period is generally a bad idea, because it allows bad queries to run rampant on your server. It seems to me that there is something very wrong going on with your Oracle database. If you aren't the admin, you should contact whoever is and ask them to look into it.