Does it take 50 seconds to run the query or 50 seconds to load the page? Are you connecting to the DB using the same driver? How about your network?
On Wed, 20 Feb 2002, Dave Carabetta wrote: > I am working in a CF 4.5 SP2 on Solaris environment. > > I have a query which I run via TOAD and SQL Plus which comes back in 700 ms > at most. But when I run it through a CF template, it takes over 50 second s > on average. I have tried connecting to my database via both ODBC and the > Merant Oracle driver, and nothing has improved. I ran a detailed Explain > Plan analysis on the query and tuned the proper indexes with my DBA. But > that hasn't helped either. I also use <cfqueryparam> religiously, and whi le > it works wonders on my other queries, this one is still agonizingly slow. > > Can anybody point me in a direction to try and track this down? > > Thanks, > Dave. > > _________________________________________________________________ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > ______________________________________________________________________ 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