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).