Slower loads from Oracle in QV after Windows upgrade

doherja — Fri, 14 Oct 2022 20:27:01 GMT

Hi, we have two QlikView publishers in a clustered environment, with the same hardware. Everything else about them is the same except for Windows versions: same QV server and desktop versions; same Oracle client, tnsnames and other oracle config files, and OLE DB driver version; same admin account and Oracle user, and same registry settings for fetch and chunk sizes.

After upgrading one of the servers from Windows Server 2012 64-bit to 2019 Standard (with the idea of doing both), loads from Oracle take many times longer than on the non-upgraded server. Loads from QVDs perform the same on both. The Oracle client version supports both OS's. As part of investigating, we logged into each server and tried a load in QV Desktop, and the progress window shows the upgraded instance as getting 16,000 rows at a time, vs. 32,000 in the 2012 server.

Can't reproduce the difference using SQL*Plus.

Any suggestions, short of rolling back Windows?

Thanks

topic Slower loads from Oracle in QV after Windows upgrade in App Development

Slower loads from Oracle in QV after Windows upgrade