> I've just started to > learn about Stored Procedures, and benefits of running/referring to > queries on the SQL server level (cfstoredproc) as opposed to CF level > (referring to the query, not the stored proc)
I'm not sure what you mean by "running/referring to queries on the SQL server level (cfstoredproc)". DISCLAIMER ;) I'm not a SQL Server guru, soemone please correct/complete me if my understanding is wrong/unclear. Basically, a Stored Procedure is a piece of SQL code that resides in the RDBMS and as already been checked for syntax errors and been precompiled where as when you submit a query through ODBC it has to be parsed for syntax errors, then compiled and run, thus a stored procedure would return results faster since it is already parsed and compiled. > Would there be any > benefit to setting the application var (myList) based on the stored > procedure (the query in SQL)? Is this even possible? Would you notice > a performance difference? Or.. would it be best to just run query in the > application file? I don't really understand that statement. What do you want to achieve with that list? Why set it as an App variable? >From what I get, it doesn't make a huge difference in performance whether you use a stored procedure or a CFQuery to return a one row recordset. It might be good if you plan on putting ALL your apps SQL code in stored procedures, just for the sake of separting the SQL code from the CFM code or whatever logic is behind that. Some DBA's prefer it that way since they don't have to bother with CFM code. For simplicity, maybe a bit of lazyness, I would just use a CFQUERY from what I understand. If you could give more details maybe I, or someone else, could advise you better.. Marc - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Marc Campeau" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
