> http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid =16005&forumid=4
Great explanation thanks Jochem. Interested to hear about the dbms hashing the query and checking if the hash exists as a key to execution plans. Is there no risk of two queries being hashed to the same value? I figure with hashing since you end up with a string of finite length based on a string of indefinite length that there must be some duplication of hashes. So I've never used hashes as a key like this (e.g. when manually building a cache of some data such as XML). Is it common practice to throw caution to the wind and do this? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
