I use stored procs and views to do my reports. I find this be the best unle ss my report is dynamic.
HTH Clint ---------- Original Message ---------------------------------- from: Amanda Stern <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Sun, 24 Feb 2002 14:41:10 -0800 (PST) Hello, The application I am working on has about 10 reports that are being run every month. The queries for these reports are written in the CFML page using <CFQUERY>. I was wondering if it would be better(execution timewise) to write a stored procedure on the MS SQL side and calling it in the CFML page. The few applications that I have seen have not used stored procedures...does anyone out there use stored procs for report writing...is this not common practice??? Thanks! __________________________________________________ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
