I don't believe you will be able to speed this up without changing the query/storedproc. Other than that, I would make sure that there are no nested html tables (can slow browser interpretation), and I might conside r a hardware solution (ram, cpu, etc...). I can't think of any other way to speed that up.
:( Dave -----Original Message----- From: David Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:16 AM To: CF-Talk Subject: Large Query return I have the need to display a query that is returning 43000 plus rows. Th e query itself is in a storedproc and completing within 30ms. But the outp ut either through cfgrid or table is very slow. Any suggestions on how to speed this up. I know its a huge query and wish i could change it. ______________________________________________________________________ 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
