I don't know about 1 giant CFC, but we have most of our data access in several (about 10 different) cfcs. We use sql queries, not stored procs, but the idea is the same. We cache them in the application scope. As long as you are careful with var'ing all your local variables, performance should be good.
Russ > -----Original Message----- > From: Brian Peddle [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 24, 2006 7:29 PM > To: CF-Talk > Subject: All Stored Procs in 1 CFC? > > I have worked a few companies where they use .NET and know of several > other companies who follow this process. They have a generator that > reads all the stored procs and creates the needed code in .NET to make > the calls to the stored procedures in classes. All this is done > automatically and the file is never edited by human hands. One of the > cool things is that if a stored proc is altered and the file is > recreated on build any page calling that class will fail and they can > quickly and easily see what needs to be fixed. The other cool thing is > all the SQL is in one place. > > Anyway, has anyone ever done this in CF? Not so much the auto generate > stuff (although be good to know) but have one monster .cfc with all the > calls. Since it isn't compiled like .NET performance may be a huge > issue but not sure. Or maybe if this is tossed in application scope it > would fly. > > Thoughts? > > Hope this made sense. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257952 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
