exactamundo! Going with XML, generated in the SQL even, returned to the view. Use the 'bean force' for manipulating the data.
shazzam! DK On 8/29/06, Kris Jones <[EMAIL PROTECTED]> wrote: > > > So, in the gateway I have a method that > > grabs all 1100 rows, loops over them creating a bean from the row, and > > adding the bean to a array which is eventually returned. Performance > > absolutely sucks. It takes about 15 seconds to do this. Any ideas on > how > > to speed this up? > > Unless you are actually using the 1100 beans on the destination page > (beyond just outputting the items as rows), this procedure is really a > waste of resources. Yes, it's "correct" OO approach, but at what cost? > If all you need is a bean on a specific row's selection, output > directly from the query, and do bean creation of the selected row. > > Cheers, > Kris > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251392 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
