https://community.qlik.com/t5/Connectivity-Data-Prep/Different-Oracle-client-OLE-DB-versions-and-performance/m-p/1948373#M10980 <P>I'm evaluating to upgrade from oracle12 drivers for OLEDB to either oracle19 or oracle21.</P> <P>The setup I'm running for QlikSense is pretty much identical to what is described her<BR /><A href="https://community.qlik.com/t5/Qlik-Sense-Documents/How-to-set-up-an-Oracle-OLE-DB-connection-in-Qlik-Sense-step-by/ta-p/1549395" target="_blank">How to set up an Oracle OLE DB connection in Qlik ... - Qlik Community - 1549395</A></P> <P>I have a test table in an Oracle database, with 8 million rows. The DB is for test purposes and it is not heavily used.</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="50%"><STRONG>Version</STRONG></TD> <TD width="50%"><STRONG>Time (about three tries each)</STRONG></TD> </TR> <TR> <TD width="50%">oracle12</TD> <TD width="50%">50 seconds (+/- 5 seconds)</TD> </TR> <TR> <TD width="50%">oracle19</TD> <TD width="50%">more than 15 minutes (aborted)</TD> </TR> <TR> <TD width="50%">oracle21</TD> <TD width="50%">1 min 10 seconds (+/- 5 seconds)</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Have anyone experienced something similiar?</P> <P>Any solutions?</P> <P>For reference: the QlikSense servers are running virtual Windows Server 2019, 24 gb RAM, 4 cpus at 2,2 GHz , (Xeon E5-2699)</P> Mon, 27 Jun 2022 08:43:30 GMT qliktime 2022-06-27T08:43:30Z https://community.qlik.com/t5/Connectivity-Data-Prep/Different-Oracle-client-OLE-DB-versions-and-performance/m-p/1948373#M10980 <P>I'm evaluating to upgrade from oracle12 drivers for OLEDB to either oracle19 or oracle21.</P> <P>The setup I'm running for QlikSense is pretty much identical to what is described her<BR /><A href="https://community.qlik.com/t5/Qlik-Sense-Documents/How-to-set-up-an-Oracle-OLE-DB-connection-in-Qlik-Sense-step-by/ta-p/1549395" target="_blank">How to set up an Oracle OLE DB connection in Qlik ... - Qlik Community - 1549395</A></P> <P>I have a test table in an Oracle database, with 8 million rows. The DB is for test purposes and it is not heavily used.</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="50%"><STRONG>Version</STRONG></TD> <TD width="50%"><STRONG>Time (about three tries each)</STRONG></TD> </TR> <TR> <TD width="50%">oracle12</TD> <TD width="50%">50 seconds (+/- 5 seconds)</TD> </TR> <TR> <TD width="50%">oracle19</TD> <TD width="50%">more than 15 minutes (aborted)</TD> </TR> <TR> <TD width="50%">oracle21</TD> <TD width="50%">1 min 10 seconds (+/- 5 seconds)</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Have anyone experienced something similiar?</P> <P>Any solutions?</P> <P>For reference: the QlikSense servers are running virtual Windows Server 2019, 24 gb RAM, 4 cpus at 2,2 GHz , (Xeon E5-2699)</P> Mon, 27 Jun 2022 08:43:30 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Different-Oracle-client-OLE-DB-versions-and-performance/m-p/1948373#M10980 qliktime 2022-06-27T08:43:30Z