I don't agree to the 1st option ,something should be done about the issue else the CFC file would keep on growing and the application would take too long.
My take on it would be ,assuming that you are using SQL server(as I have more experience in creating stored procedures in SQL Server) convert the in SQL queries in CFC to Stored Procedures and call them in the CFC and then load the values into Structures.This might be time consuming as it seems that there are too many functions in the same CFC. NK >I have a single CFC file that holds all of the SQL CFC's for an >application -- every SQL read, write, or delete uses a function in >this CFC, and every page calls several functions. The problem is that >over time, this file has grown (hundreds of functions, almost 200kb) >to the point where it is slowing down the startup of the application >significantly (30 seconds or so, and it uses a lot of memory). Seeing >as this is a very large app, having to go through and rework this is >something that I want to do once and only once. My understanding of >the factors that go into CFC performance is both incomplete and >imperfect, so I'm looking for some advice. > >As I see it, I have the following options, in order of ease of implementation: >1) Leave it as it is >2) Move each "family" of SQL functionality (i.e. all news functions -- >between 3 and 10 CFC's per family, on average) into its own separate >CFC. This would entail touching every page on the site and creating >about 18 new CFC files. >3) Move each individual function into its own CFC file. This would >entail creating hundreds of new CFC files as well as touching every >page on the site. >4) A combination of using the existing sql.cfc file as some sort of >switchboard, forwarding requests to CFC files created in either option >2 or 3. Wouldn't need to revise any pages but the CFC file(s), but I >have no idea if this is possible or how to accomplish this without >creating mountains of new code. > >Does anyone have any advice for my situation? > >Thanks, > >Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319669 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
