topic Re: Document performance in QlikView

Document performance

Thu, 18 Jun 2015 08:05:49 GMT

Hello community,

This week I created a document for my company. The idea was to put all reports in one document, with a self-created navigation menu instead of using the standard tabs.

Everything is working now and we are now in our beta fase. Sadly, when browsing this document in a webbrowser everything becomes very slow. It works fine in QV Personal Edition.

The .qvw file is now sized 630MB in size.

Im pretty sure our data model is not the problem, see below:

Now, we still have to upgrade our server to 16GB RAM instead of 8, but will this have any influence on the webclient usage?

Are there any other things I can look into?

Any help would be greatly appreciated, and im sorry if my thread is lacking information, ill add whatever is missing!

Regards,

Jeroen.

Re: Document performance

datanibbler — Thu, 18 Jun 2015 08:27:50 GMT

Hi jeroen,

your data_model looks fine. That is most probably not the issue. And 630MB is not much for QlikView (still, it might be too much for the Browser, I don't know for sure)

When you watch the execution_window, it that slow or does it finish and then the GUI takes time to load?

Have a look into the log, that will tell you the exact times of every line of code - you will spot if anything in there takes time.

But you say it's fine in the Client - so I guess the problem is in the Browsers or in your Wifi - data has to be transferred back and fro.

Maybe someone else has more experience than myself in the use of the AJAX client via AccessPoint.

Best regards,

DataNibbler

Re: Document performance

sujeetsingh — Thu, 18 Jun 2015 08:31:26 GMT

Cross Check few things in your application:

- are you using much nested if expressions or complex calculations in your application

- repetition of rows which are not needed

- hardware the most important thing

For more things follow this doc .

Best Practices for Data Modelling

Re: Document performance

Thu, 18 Jun 2015 08:33:03 GMT

Hi DataNibbler,

thanks for your reply!

I'm not working on wifi and my network speed is fine, so that can't be it.

Btw I tested several browsers and computers.

Ill go look into the logs like u suggested!

Thanks!

Jeroen.

Re: Document performance

Digvijay_Singh — Thu, 18 Jun 2015 08:33:45 GMT

Are you loading through QVD or directly through ODBC from source?

Re: Document performance

Thu, 18 Jun 2015 09:23:05 GMT

QVD

Re: Document performance

Thu, 18 Jun 2015 09:46:53 GMT

Hey,

Use Document analyzer and remove unnecessary fields, minimize charts which are not required in first view, try to replace ifs with set expressions, compare integer values.

Re: Document performance

Thu, 18 Jun 2015 14:12:40 GMT

Thank you all for your suggestions, im gonna look at them all one by one, im sure one or several suggestions will improve my performance!