I've got a bit of an issue with the site code (more or less a content management system) that I've been adding to over the past several years.
The core of my code is a CFC that contains all of my SQL operations in separate functions. I went with this approach for a number of reasons: it pulls the SQL out of the presentation layer, it takes a "black box" approach so that I can switch from SQL to stored procedures, or views, etc., and it allows me to support different database types. It's worked very well, but there's a problem -- when the site initially loads, it takes forever (well, about 30 seconds). I'm assuming that this is because the SQL CFC has grown to almost 4,000 lines of code. Right now, I'm giving serious thought to breaking the SQL CFC up into multiple separate CFC's (one for each primary area of functionality); i.e. one CFC for the content management section, one for logging, one for user management/login/etc., etc. which would leave me with about 10 separate CFC's but would have me touching every single page that calls the SQL CFC (I'm using cfinvoke). Will this yield me the performance improvements that I'm looking for? Are there any best practices for CFC performance? 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:314378 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
