topic Re: Performance Issues in QlikView

Performance Issues

ivandrago — Thu, 30 Jun 2011 21:37:07 GMT

Hi,

I am recently having performance issues i.e. taking a while to switch sheets and then loading graphs once in that sheet?! Can anyone out there advise what to change or look out for and if there are any tools out there that would tell me what data to clean up?

Thanks

Performance Issues

Anonymous — Thu, 30 Jun 2011 23:58:18 GMT

Well, look for the amount and complexity of sheet objects. Under Settings > Document Properties > General, you can export Memory Statistics that should show you how long it takes to load certain objects etc.

Performance Issues

ivandrago — Fri, 01 Jul 2011 08:47:39 GMT

Johannes, Thanks for this! Which field would you be intesrested the most? i.e.Bytes, Size..etc?

Also I'm sure I seen a Document within the forums that would tell you the performance of a certain Documentand would tell you which fields was not used etc...are you aware of this?

Thanks

Re: Performance Issues

kaushiknsolanki — Fri, 01 Jul 2011 08:55:14 GMT

Hi,

Have a look at the attached document.

This is used to optimize the performance issue of the document. (Qlikview Application)

Regards,

Kaushik Solanki

Re: Performance Issues

ivandrago — Fri, 01 Jul 2011 09:24:52 GMT

Hi Kaushik, I have opened the QlikView Optimizer, when I have gone to my Document to save the mem file it does not save this as that file type but saves this as a text file? when i cahnge the text file from .txt to .mem, the QlikView Optimizer does not look like it recognises the file as the results are not telling me much.

Thanks

Re: Performance Issues

kaushiknsolanki — Fri, 01 Jul 2011 09:44:03 GMT

Hi,

How are you creating a mem file.

Use this method.

Go to Settings-> Document Properties-> General Tab -> Click Memory Statistic -> Give the name of that file.

And us this file in the Optimiser.

Regards,

Kaushik Solanki

Re: Performance Issues

ivandrago — Fri, 01 Jul 2011 09:54:12 GMT

For some reason it is not savingthe file as a mem extension but saving it as the following "Performance..txt" I have changed this to "Performance..mem" and seems to be working now as before I had the file as "Performance.mem".

Do you know what each field relates to?

Bytes

Count

Size

Also for some reason it is not bring across the CalcTime and AvgCalTime?

Is there anywhere that would tell me which field is not being used within the Document? As I can remit this out when loading the Document.

Thanks

Re: Performance Issues

siva_boggarapu — Mon, 04 Jul 2011 05:45:02 GMT

Hello,

After saving this document with (.mem) extension. How it will work? Can you please explain me with example.

Re: Performance Issues

kaushiknsolanki — Mon, 04 Jul 2011 07:07:58 GMT

Hi,

Once you have the .mem file of any of your application. You can give it as input to the optimiser application.

What Optimiser will do is, it will give you the total detail of your application, like what object you have used. How much is the size of that object, what is the count and many more things.

This helps you wo understand that what takes more memory and effects the over all performance of your application.

Regards,

Kaushik Solanki

Re: Performance Issues

Anonymous — Mon, 04 Jul 2011 12:22:21 GMT

I tried to save in .mem type but while opening the mem file type it doesn't give any option to open with or can say no support for open. how can we use that file as performance optimizer. Please explain.

Thanks & Regards

Re: Performance Issues

kaushiknsolanki — Mon, 04 Jul 2011 17:00:33 GMT

Hi,

If you read the full post i have given how to create a .mem file and then you will also find the optimiser application attached in the post.

once you open the application all you have to do is give the path of the .mem file.

Regards,

Kaushik Solanki

Re: Performance Issues

felcar2013 — Tue, 09 Jul 2013 17:36:08 GMT

this is old, but do you know if there are instructions for the application, on how to interprete values and react?

i installed it, and go excellent insides on my charts, but i do not know for ex. if the use of variables and many expressions in my charts are the cause of the problems. Thiis is an issue if i get a calculation over 50 million rows in a chart using a formula a created in the script.

thanks for any inside

felipe