Sounds like CF is timing out before the query is returned from the
database, but this is not canceling the database transaction. CF still
receives the query result set back from the database and is then caching
it, making the second load of the page a lot faster. Very smart behaviour
if this is what is happening.
Mark
At 05:15 PM 4/4/2001, you wrote:
>Hi,
>
>We have been getting a series of very weird error messages with CF lately.
>We have got two servers, one with CF and another with the Oracle database.
>
>The CF server page request timeout is set to 30 seconds. When we request a
>page for the first time, it always goes beyond this threshold for some
>reason (it should not take that long anyway) and we get the CF page
>timeout error message. However if we request the page again, chances are
>that everything will go ok.
>
>Another scenario:
>
> 1. We request a page for the first time with a browser, and it is
> starting to take too long to deliver...
> 2. If in that time (within the 30 seconds threshold) we request that
> very same page with another browser (on another machine) the page in
> browser the first browser gets finally delivered while the one in the
> second one starts taking a long time to deliver.
>
>It looks like if Oracle is not passing control back to CF unless this is
>forced somehow by another request done by someone else. We are trying to
>work out why are we still getting this erratic behaviour.
>
>We are using: Solaris 5.8, Apache 1.3.9, Oracle client 8.1.6.3
>
>Any ideas or comments about what could be going wrong would be greatly
>appreciated.
>
>Francisco Montes
>Spain on Line
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
