Yes you are correct. If you are executing a query with the exact type of input parameters ColdFusion returns the cached dataset. If the input parameters differ (articleid = 1 instead of articleid = 2 for example) ColdFusion gets the dataset from the database and stores it in server memory. So caching takes place on the query but, depending on the query executed.
There is an article on the MM websites stating query cache cannot be flushed ... that article is wrong. You can flush query by, using: <cfobjectcache action="clear"> The the next requests executes against the database again. This line clears out query cache/ Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:190214 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
