> The performance hit I meant was on the cf-app and then the
> inability of the
> app server (or would it be the db server?) to cache that
> query.
Oh, I see what you mean now. Yes, I that is my understanding as well. ie There
is a better chance of your database caching the query plan when the statement
is more static. Only the values change (not the column names).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:329557
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
