Hey there,
is these a query that needs to run interactive? one way that you can
approach this is to create a file that will contain all the fields (data)
that is been pulled in by all these queries, yes, it will be a BIG file, but
if you have the space on the server sometimes that is the best approach,
then you can schedule this to be run by the SQL server...
Bismarck Perez
-----Original Message-----
From: Ricq Pattay [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 12:06 PM
To: CF-Talk
Subject: multiple queries tie up web server
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
