Thanks guys. One more related question- I have Emp Name and State in the cach for Emp IDs 111,112 and 113. Not I run other query in which I want to get all the data(Emp Name and States for 111,112,113 and 114 Emp Ids).
Q- Will transfer get all these four records from DB again OR this time will it fetch just record related to Emp Id 114 from DB and rest from cach(like hibernate does...i believe)? Why I am asking- I am working on a report website. I will get some records based on some criteria. Now I change the criteria slightly(e.g. initially I was getting data for IN state. Now I included NY as well).I want that this time just the records for NY be selected from Db and rest(for IN) from cach. So that performance of the application is better. Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
