I have a process that needs to do about 500 record lookups by ID. I thought I'd do a single query of the table, pulling down the needed data for every record on file (say 1000 records, just three columns) and then use QoQ instead of hitting the database so many times.
Is there any way to index or otherwise optimize the dataset that I retrieve to optimize the query of query lookups? If I'm doing lookups using a particular column, would it help to sort the query by that column? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312635 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
