Indexing the table with our new added fields made the CF page go from
timeout to execution in under a minute.
Thank all for the input.
Casey Cook
Dave Cahall <[EMAIL PROTECTED]>@dfwcfug.org on 03/12/2001 12:23:31 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: Broswer timeout
Couple of comments:
Can the query be optimized to cut down the time?
Is the query in the CF page?
Can you create a stored procedure?
The real problem here seems to be one of efficiency. First of all, I
would recommend against putting complex queries directly on a page. Any
time you submit the query to the database, it will be slower than the
same query done as a stored procedure where the database can pre compile
the query. As Mr. Forta would say "let the database do the work"..."do
not use CF to do what the database can do more efficiently". Queries
that run for long periods are suspect. Or is the problem that it is
returning such a big result set that it takes the browser an inordinate
amount of time to build the page. One way or another, it appears that
their is a real need for some optimization.
On Mon, 12 Mar 2001 11:22:52 -0600 [EMAIL PROTECTED] writes:
> Hello -
>
> I have a quick question, I'm not sure if the e-mail below answers
> the
> question I have or not. I have a page that takes while to churn,
> lets say
> ten minutes, but the broswer shuts down after 5 minutes or less. Is
> there a
> way to increase broswer time-out?
>
> CC
>
>
>
>
> Weldon Patterson <[EMAIL PROTECTED]>@dfwcfug.org on 03/05/2001
> 02:04:14 PM
>
> Please respond to [EMAIL PROTECTED]
>
> Sent by: [EMAIL PROTECTED]
>
>
> To: [EMAIL PROTECTED]
> cc:
> Subject: timeout woes
>
>
> We have a page that involves a number of complicated queries. We
> added
> "?RequestTimeout=500" to the URL, but now after churning for 35
> seconds or so, the page goes blank and says it's done. No data; no
> errors. We've tried with and without cftransaction. The page is
> working when querying a small amount of data. Any advice?
>
> --
> Weldon Patterson
> Web Site Developer - Staffing
> Raytheon
> 13510 N Central Expwy M/S 201
> Dallas, TX 75243
> (972) 344-3011
>
>
>
>
-------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield
> anti-
> spam software. Please contact your email administrator if you have
> any
> questions about this message. MailShield product info:
> www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
>
>
>
>
-------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield
> anti-
> spam software. Please contact your email administrator if you have
> any
> questions about this message. MailShield product info:
> www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
>
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
