Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
lucas4bi
Contributor

Reload time doubled all of a sudden

Hello everyone,

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

  KEY,

  Min(Left(right(CDC,5),4)) as [MINYEAR]

Resident TAB

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

Tags (4)
8 Replies

Re: Reload time doubled all of a sudden

Is your VM using reserved memory?

lucas4bi
Contributor

Re: Reload time doubled all of a sudden

I'm gonna ask the customer, but it should be already like that.

Anyways i don't think the problem is the RAM cause i don't see the usage going up very much during the script reload.

Re: Reload time doubled all of a sudden

Whats the current size of your app ?

lucas4bi
Contributor

Re: Reload time doubled all of a sudden

it is around 30MB,it's pretty small

Re: Reload time doubled all of a sudden

then it should be an issue ....check whether any other process is consuming RAM at the same time ? or

try pushing the group clause to DB and check

lucas4bi
Contributor

Re: Reload time doubled all of a sudden

There are no other processes consuming RAM, anyway i don't think RAM is the issue because the usage is below 40%.

I belive it is something related to CPU and VMWare configuration, but i dont really know what to check with the IT, they said they've only added a new server on the environment.

jeremy_kofoot
New Contributor III

Re: Reload time doubled all of a sudden

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. 

karthiks_dwbi
Contributor II

Re: Reload time doubled all of a sudden

is it happening for many applications or for only this application ?

if it's just for this application, How long it take when you run that manually ?

Community Browser