Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ivandrago
Contributor II

Performance Issues

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

1 Solution

Accepted Solutions

Re: Performance Issues

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

11 Replies
jsn
Honored Contributor

Performance Issues

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.

ivandrago
Contributor II

Performance Issues

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

Hi,

   Have a look at the attached document.

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

Regards,

Kaushik Solanki

ivandrago
Contributor II

Re: Performance Issues

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

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

ivandrago
Contributor II

Re: Performance Issues

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

siva_boggarapu
Contributor II

Re: Performance Issues

Hello,

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

Re: Performance Issues

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

shubham_kumar
Contributor III

Re: Performance Issues

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

Community Browser