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
