7500 Queries....? holly molly batman. Ok, just guessing but it sounds like
your generating a report to me....Here is what I would look at:
1) Apache (not familiar with Apache) must have some limit being set to the
number of concurrent process's, and it it not queuing them or they are
timing out, perhaps increase this setting.
2) Change the template so it calls another process (Schedule or batch)
execute's the monster template in batch mode (no webserver involved), which
writes the output to a static file or emails it to the user. Then the user
can check the static file after a few minutes or wait for an email. There
is a nice tag CF_FileWriteText that you can wrap around your code that
nicely output's your html or whatever you need to output.
Hope it helps...
-Adrian
-----Original Message-----
From: Ricq Pattay [mailto:[EMAIL PROTECTED]]
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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
