When you say "...the page goes blank and says its done." what do you mean?
What's telling you that the query is done?
An initial thought:
A 35 second query sounds like there might be an issue with the query itself.
Are you sure that your query is correct? Are you using join statements that
are bracketed correctly? Are you using some sort of CF Looping structure
that is incrementing correctly?
Suggestion... run the Cold Fusion SQL error checking feature to look at the
SQL statement itself. Copy this generated SQL statement and run it directly
against your database to see if it returns records correctly. This will go a
long way to further pinpoint the issue...
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Weldon Patterson
> Sent: Monday, March 05, 2001 2:04 PM
> To: [EMAIL PROTECTED]
> 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
