Stored Proc Performance vs CFusion
i'm relatively more experienced sql , variety of reasons discussed elsewhere (performance, security, portability html/flex , mvc code organization) building app more cfcs , stored procedures. that said, initial iterations <cfquery> based, have moved relatively simple procedure (which sets , feel home page depending on visitor ip) <cfquery> to <cfinvoke> cfc <cfstoredproc> mysql 5.1 stored procedure long story short, works latter taking longer load (exact same data exact same devserver machine both cf8 , mysql on it) significant factor (probably 100 times). any thoughts on why? (fwiw server p4 800 mhz 1.5 gb ram) > <cfquery> > > <cfinvoke> cfc <cfstoredproc> mysql 5.1 stored procedure you're doing 2 operations in latter compared 1 in former. how apples-n-apples compare: cfquery vs cfstoredproc (eliminating the cfinvoke purposes of testing)? version of cf on? cf's traditionally been pretty slow instantiate cfcs (it...