COLLIE David wrote: > > Not got anything to do with MM AFAIK... It's more a database issue cos > it uses bind variables which denote that the value will prolly change > from query to query but still allows the database to build a compiled > execution plan.
There are no technical reasons why query caching with bind variables is impossible. The only thing you need to make sure is that you don't just use the query string and name as keys, but the bind variables as well. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190255 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
