Slower loads from Oracle in QV after Windows upgrade
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.
