Perhaps instead of saying "queries", I should have said Remote Object calls. I hope that will make things a little more clear as to what my problem might be.
Thanks! ====================== Now, the remote db has over 100 tables and thousands of records. So a lot of queries (Should say "remote object" calls) are being made and I think I am running out of Java Heap Space in Coldfusion. I only suspect this because the application would hang after running X amount of queries - and it is not consistent......
