I have a CFC that has a function that builds a query statement dynamically.
Part of the specific function loops over the data passed and sets the values.
In doing so it checks to see if data if of a specific type. Part of
that check involves looking at a property table defined like so;
fieldname | fieldtype
myfield | varchar2
My question is having CF make constant calls to this lookup query is
that going to have a significant impact on performance? On average
the dynamic query will have to loop over about 10 -20 fields, thus
calling the lookup that many times. Also the function itself may be
call 10s of times a day possibly even in the hundreds.
My though is to Cache the lookup query so each result set is cached.
Eventually the lookup may get moved into Oracle just not right now.
Does that seem reasonable or does someone have a better suggestion for
performing the lookup to get datatype (maybe query or query solution).
thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190827
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
