Thanks for the responses so far. More info:
We're running CF Server 4.51 Enterprise, with the Oracle 7.3 native drivers.
And *all* requests to the web server are refused, not just those to the same
datasource. So this sounds more like a web server problem (as Robert said).
The page in question isn't a report, but a dynamic grid of enrollment counts
for multiple courses held at multiple times. Each course/time combination
has 4 queries associated with it, 3 of which are "select count(user_id)..."
Each course/time intersection has javascript pop-up windows associated with
it so my user can add/drop/move students to/from other intersections on the
schedule grid.
I can't really cache the query because there's 7500 of them! :-)
I don't know enough yet about writing stored procedures to investigate this
route. Maybe this is a good time to learn? But would using SP's even help if
there are so many little queries?
----- Original Message -----
From: "Edward Smith" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 1:10 PM
Subject: Re: multiple queries tie up web server
> We've had problems with Oracle drivers being single threaded-like. In
> other words, if a long running query is just waiting out there, other
> requests to that datasource have to wait.
>
> What version of CF and what oracle drivers are you using?
>
> Ricq Pattay wrote:
> >
> > I have a CF page that contains approx 7500 queries against an Oracle
> > database via an Apache web server. Of course this page takes a while to
load
> > (3 minutes or so), but my user is ok with that because she does so only
a
> > handful of times per day.
> >
> > What is not ok is that, while this page is loading, all other users of
any
> > CF app on that web server cannot access any page -- they will receive
> > Apache's "server is too busy to handle request" error message. Any ideas
on
> > how to work around this? Reducing the number of queries from 7500 isn't
> > really an option, unfortunately.
> >
> > Ricq Pattay ~ [EMAIL PROTECTED]
> > College of Veterinary Medicine
> > University of Minnesota - Twin Cities
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
