I don't have any great ideas, but one thing I'd do is put the connectstring into the CFQUERY itself to see what happens. If things go faster then the problem is in accessing the tnsnames.ora file.
We had some problems during load testing CF4.5,SP2 and Oracle 8.1.7 where the problem was trying to access tnsnames.ora too often. Putting the connectstring info into the CFQUERY fixed that. Also, I've heard of using "sql trace/TKPROF" to debug slow Oracle queries. I haven't used it myself, but info about it should be in the Oracle docs. Chris Norloff ---------- Original Message ---------------------------------- From: "Simon Whittaker" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Tue, 1 Apr 2003 10:54:49 +0100 > >Hi all, > > > >I have a bit of a problem I wouldn't mind some help with - We are using CF5 and >Oracle 8i(8.1.7.0.0) (using Native drivers) and our application is running REALLY >slowly. We have tuned the queries as much as we see possible and cached wherever >possible although the neature of the beast makes caching a bit of a pipe-dream. I >have been doing some debugging and found that the first query of the page is taking a >very long time: > > > >getnews (Records=3, Time=2359ms) > >SQL = > >SELECT news_id, headline > > FROM news > > WHERE show = 1 > > ORDER BY newsdate desc > > > >These are not big records and the query is very fast if I perform it through SQLPLUS >or TOAD (Oracle gui devlopment tool) - the rest of the queries on the page are then >performed in regular time. > >A tnsping of the box produces: > > > >Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=*REMOVEDHOSTNAME*)(PORT=1521)) > >OK (40 msec) > > > >so the connection to the oracle instance itself seems to be a reasonable time. > > > >Does anyone have any ideas that could help us out as it is starting to cause problems > > > >Many Thanks > > > >Simon > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
