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 ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists