> 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.
I don't have Oracle experience, so I'm going from SQL Server experience...
The problem is that it's speaking to the Oracle server 7,500 times on the
one template, which means that it's handing the maximum queries to the
server in one go, and then waiting for the next queries
Can't you put the queries into Stored Procedures in blocks and get it to run
those (thus returning multiple queries in one handle), which will be faster
talking to the database
Also, you might want to try using larger queries, and then using CF to break
them up (i.e. with Joins or Unions)
Is the result something that NEEDS to be done 2-3 times a day, or if it's a
report, why can't it be run at slow times, and then email the result to the
client... we do that with reports that take a long time to build, thus
lessening the strain during the busy periods
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
