You should clarify what you are delivering to the end user, since that is an essential piece of missing information. As a general rule, when dealing with large amounts of data, do as much filtering of the data on the database server as possible, and only send CF what it needs in order to generate the Web site content visible to the user. Database servers are optimized for handling data and they are usually running on hardware that is significantly more powerful than the hardware driving a Web server.
-Mike Chabot On Sat, Mar 21, 2009 at 6:37 PM, Richard Cooper <[email protected]> wrote: > > 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:320800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
