Skip to main content
M
mcaselle
Participating Frequently
March 3, 2010
Question

Coldfusion 8.01 and Oracle 11g

  • March 3, 2010
  • 1 reply
  • 1090 views

We have been running CF 8.01 with Oracle 9i for 2 years without any major performance issues.  Recently upgraded the Oracle database to 11g and have started noticing performance and slow reponse time issues.   Nothing we have looked at looks out of place, yet still is slow...appreciate any guidance.

Thanx

    This topic has been closed for replies.

    1 reply

    Owainnorth
    Owainnorth
    Inspiring
    March 4, 2010

    Are you using Coldfusion Enterprise or Standard? Enterprise has the built-in DataDirect drivers which I've found to be very good and have never had any issues with whatsoever.

    In saying that I've also run Standard with the JDBC driver and have also never had any issues. However if that's what you're using I'd suggest a driver upgrade.

    O.

    M
    mcaselleAuthor
    Participating Frequently
    March 4, 2010

    We are running Enterprise.  I have dropped and rebuilt the datasources with the Administrator as well with no sucess.  We are able to run the queries outside of CF and they run pretty quick - so we believe we have rulled out indexing issues.

    M
    mcaselleAuthor
    Participating Frequently
    March 4, 2010

    ...getting a little ahead of my self in this... the dtabase is 10g not 11g.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices