Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Very low performance while connecting QV x64 to Oracle 10g x64 database through OLEDB

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Very low performance while connecting QV x64 to Oracle 10g x64 database through OLEDB

Last Update:

Jul 8, 2021 6:08:49 AM

Updated By:

Sonja_Bauernfeind

Created date:

Aug 13, 2013 7:18:02 PM

Connecting QlikView with Oracle 10g x64 database leads to a successful connection but slow loading speed. Example: For a table with 60 columns, 280k rows, it takes 7-8 hrs to load. 

 

Environment:

QlikView 

 

Rather than using Oracle 10g, choose the Oracle 11g client ODBC driver. Verify that Load performance improves.

Performance between drivers from different database vendors may vary. To verify if the issue is with the QlikView or Windows machine, perform tests such as 'loading data by connecting to other databases such as Microsoft Access or Excel by using the same driver', and from another Windows machine (32 or 64 bit , Server 2003 or Server 2008 or Server 2012).

Labels (2)
Contributors
Version history
Last update:
‎2021-07-08 06:08 AM
Updated by: