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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89
70.4
