Well, how are you assigning the variables into the bean, using evaluate() or query[column] notation? Evaluate could be killing your speed possibly?
Chris -----Original Message----- From: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 29, 2006 1:18 PM To: CF-Talk Subject: performance and CFC gateways Ok, working on some Flex apps here using CF on the backside. Got the usual cadre of bean, gateway, and DAO cfcs. I have a table with 1100 rows in it I want returned via the gateway. 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? Post Script: For those not yet Flexified...returning a array of beans here is the uber way to do it as I can map a CFC bean direct to a AS bean and some magik happens. I switched the above to return a string of XML and its way faster, but looses the typing. -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:251384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
