Solved: How to do performance testing in QV - Qlik Community

Anonymous · ‎2013-10-28

Hi,

can someone point me to reliable method of doing performance testing in QV?

For example, if you want to see which expression or calculation is faster, how would you make this decision?

So far, I learned:

1) calculation time in Sheet object properties are often show 0 because of QV cache. Some people say you need to do reload / reopen a document to reset a cache, but for me it did not always work. I also tried cache working set option in document properties and setting it to 0 - that did not make any affect at all. So how to do a clean test and measure calculation time with no caching?

2) even if calculation time is not 0, I am learning the hard way that it is actually includes waiting time for other objects to complete. So if you have 2 charts, calculation time for the second chart (sometimes) will include waiting time for the first one.

So looking for some best practices / guidance on how to get pure calculation times for objects.

Miguel_Angel_Baeyens · ‎2014-01-02

Borys,

You are speaking about Miguel García author of QlikView 11 for Developers - QlikView Book.

There is a group in QlikCommunity dedicated to Scalability, you can check it here. There you will find how to test, Scalability Center best practices and tools and how-tos.

Miguel

View solution in original post

Anonymous · ‎2013-11-21

hi, no one is doing any testing in QV cannot comment on my question? please...

Report Inappropriate Content · ‎2013-12-19

Hi,

If you still didn't get answer to above question, do reply me. i am working on performance testing.

Regards,

Piyush

Anonymous · ‎2013-12-30

yes, it would be helpful if you can share your methodology. thanks

Report Inappropriate Content · ‎2013-12-31

Hi,

Borys you can use script to find out rows in your data model and total time required for loading those rows. so, gradually you will increse the data you will be able to find out how much reload time is increased on increase of particular no of rows.

Regards,

Piyush

Report Inappropriate Content · ‎2013-12-31

Hi Borys,

First Run the query in your ETL/DB and run it in your application.Your reloading time/Record fetching time ll derive your expectation.

Thanks.

Report Inappropriate Content · ‎2013-12-31

Hi,

I case you are fetching data from DB. you can use two separate qvw. one for coverting data into qvd and other to use those qvd. it will reduce your load time for application qvw.

regards,

Piyush

Report Inappropriate Content · ‎2013-12-31

Hi Mohanty,

Can u send me that document too.

Regards,

Piyush

dmohanty · ‎2013-12-31

Hi Piyush,

The document I have already attached in my above reply. Please download.

Anonymous · ‎2014-01-02

awesome, looks like this is exactly what i was looking for! thanks, DMohanty