G'day. >I would probably abstract *Data Manipulation to Java/PL-SQL/T-SQL to Stored Procedures*
We've thought about the Java option, but lack the skillset here currently (we're just a CF shop... Hence using CF). That and we've got... Err... *many* lines of CF to deal with, and it's just not expedient to replace it all with Java stuff. Esp if the chief reason for doing it is working round a bug in CF! If I had my time again, I never would have touched CF in the first place, to be honest. SPs aren't my strong point, but from what I could gather of MS-SQL SPs they wouldn't be suitable for what we need to do, due to the dynamic nature of the possible SQL. An SP can execute dynamic SQL, but it's supposedly frowned upon. And just replacing one bad way of doing things with another bad way of doing things ;-) And CFMX's support for SPs sux anyhow. > All the data validation/business logic/other can be done within CFC's. Sure. > No need to write multiple SQL Statements to update multiple fields or write if Conditions checking for Structs or Data. Well you would be. Just in the SP or in Java instead of CF, surely. Unless I'm missing part of what you're on about. But it's moot, anyhow: it ain't an option for us @ present. It's still always good to discuss this stuff, though, don't get me wrong (maybe not on a CFC-centric mailing list, though) > Every Method within CFC are compiled to its own Classes... so if you have 20 methods(4000 lines) within a CFC and you call 2 Methods... (dunno how you arrived at the above statement, really. It's not based on anything *I* said, anyhow). > How are you executing 4000 Lines Code? The cfquery() function is about 250 lines long. The code in the included file is about 100-odd lines long. And it's included within cfquery() about 30-odd times. If I was to do what was suggested and de-factor the included code, that'd make 250 + (100 * 30). I don't have the de-factored code in front of me @ present, but it was about 3800 lines long, or thereabouts. Cheers for the reply. Adam ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
