Hi all, I've a large query with a large number of recordsets.
Essentially I'm joining a several tables which creates 10,000+ results This bit works fine. I also need to join to a table of images increasing the number from by a factor of 10 to approx 100,000 results. If I do via CF it works just about ok on our dev servers with 64bit servers but we have 32 bit on production it fails due to lack of jrun memory. I've tried via stored procedures, and this doesn't seem to improver things. Any ideas how to get this ok. NOTE: I expect to be working with larger records sets in the future. ADDITIONAL Note: I can't upgrade our production servers to 64 bit :) Any advise would be much appreciated. Thanks, Richard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
