Do this one: >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.
I'm assuming you mean "between 3 and 10 /functions/ per family" - each category of functions should sit in a single component. Remove the original sql.cfc once you're done, so you can confirm it is not in use. But before all that, make sure you have regression tests of all important functionality (preferably all functionality) before even starting, so you can check if you've missed or broken anything. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:319670 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

