>I found that querying the database directly actually took less time than >doing a query of queries... particularly when doing large numbers of such >queries. > >Databases handle queries of large record sets far better than coldfusion >does.
Very true. To my knowledge CF has no indexing capabilities so for large recordsets, QoQ is pretty slow. I try not to use it if I expect the recordset to be more than a thousand records or so. --- Mary Jo ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272812 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
