9 Replies Latest reply: May 23, 2011 11:19 AM by Daniel Rozental RSS

    Slow Oracle ODBC and OLE DB Connections

    jasondyer

      I am currently configuring a new 64-bit server to run the 64-bit version of QlikView Publisher 8.5 and QlikView Developer 8.5. Everything is up and running and seems to be working. However, I am having some difficulty reloading QlikView apps that make use of Oracle OLE DB or ODBC connections.

      Whenever I reload an app that contains an Oracle connection, it takes about 7 minutes for the query to start. If there are multiple queries in the app, it takes about 7 minutes between each of the queries plus the time it takes to actually run each query. On our 32-bit server, these queries start immediately.

      Am I missing a configuration step with Oracle on my server? Is the server taking too long as there is some sort of delay in authentication? Any ideas on what is causing the delay?

      Server Info:

      • Windows Server 2003 R2 Enterprise x64 Edition (SP2)
      • Oracle 10.2.0 (64-bit) -- naming methods is handled locally via tnsnames.ora
      • QlikView Publisher 8.5
      • QlikView Developer 8.5

      Let me know if you need more information.