Query Time

Expand Post »

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:

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

Similar Threads

Query on a large table too slow in MySQL
Need help to build a query in MS SQL
query problem (delimiter?) in PHP
Query optimization in PHP
Apache redirection? in Linux Servers and Apache

chicago1985

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

36 posts
since Nov 2007

Permalink

May 22nd, 2008

Re: Query Time

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.

cmhampton

Reputation Points: 23

Solved Threads: 10

Junior Poster in Training

Offline

79 posts
since Feb 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ColdFusion Forum Timeline: Database List

Next Thread in ColdFusion Forum Timeline: ColdFusion and WMI Query

DaniWeb Message

Cancel Changes

User Name
Password