how big ias this property table and how much does it grow? Caching might work but if it doesn't grow/change much why not just query it once and make a simple lookup structure in the application scope.
Adam Haskell On Mon, 17 Jan 2005 15:53:20 -0500, sonicDivx <[EMAIL PROTECTED]> wrote: > 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. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190830 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
