What are you doing with this recordset? Can it be broken down into manageable chunks? CF excels at displaying data, and displaying 10,000 records isn't practical. Are you doing this one time, or with every page request?
>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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:320801 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
