I can run a flat query on 800 records in Query analyzer and it finishes
instantly.

If I run in through our new infrastructure as CFM, it takes 5 seconds, which
is insanely slow.

System: Distributed, clustered.

Two apache 2.0 web servers, clustered by Cisco hardware, using web connector
to JRun cluster ( 2 ) of CFMX7 applications.

All on: Xeon 64bit, Suse Enterprise Linux 9, 3 GB on Apache 8 GB on
JRun/CFMX7 RAM.

All other processing, CFMX included, is lightning fast. JDBC to Oracle 10i is
also lightning fast.

Any ideas?