a client started experiencing very slow reload times all of a sudden.
They have a QVW that reloads every hour, average time was 25 minutes, it has been like that for years.
Less than a month ago the reload time startet to range from 55mins to 1 hour and 10 minutes.
Nothing changed in the script and the amount of data is almost the same as before.
I have checked and it seems like it's working way way slow on group by clause now, even very simple ones. It takes about 10 minutes to calculate
Left join (TAB) load
Min(Left(right(CDC,5),4)) as [MINYEAR]
Group by KEY;
on a table with less than 1M records.
what could it be?
The only thing the client told me is that they have added a new server on their VMWare environment, but all the machines should be balanced. We have made all the windows and VMWare drivers update on the machine just to make sure everything is up to date.
No other changes have been made to the environment.
Qlikview 11.20 SR4 is installed on a Windows Server 2008 SR2
Is there any software that may be locking files such as Anti-Virus or is the file in a shared location? I know we had several issues related to anti-virus software locking files/folders and the connection between our file repository server and the publisher/app servers was being hindered. Once these were resolved our reload times went back to normal.