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:319668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
