topic Re: How to do performance testing in QV in QlikView

How to do performance testing in QV

Anonymous — Mon, 28 Oct 2013 15:08:38 GMT

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.

Re: How to do performance testing in QV

Anonymous — Thu, 21 Nov 2013 16:44:46 GMT

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

Re: How to do performance testing in QV

Thu, 19 Dec 2013 13:06:38 GMT

Hi,

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

Regards,

Piyush

Re: How to do performance testing in QV

Anonymous — Mon, 30 Dec 2013 14:52:32 GMT

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

Re: How to do performance testing in QV

Tue, 31 Dec 2013 06:59:20 GMT

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

Re: How to do performance testing in QV

Tue, 31 Dec 2013 07:10:36 GMT

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.

Re: How to do performance testing in QV

Tue, 31 Dec 2013 07:14:09 GMT

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

Re: How to do performance testing in QV

Tue, 31 Dec 2013 07:26:45 GMT

Hi Mohanty,

Can u send me that document too.

Regards,

Piyush

Re: How to do performance testing in QV

dmohanty — Tue, 31 Dec 2013 07:29:40 GMT

Hi Piyush,

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

Re: How to do performance testing in QV

Anonymous — Thu, 02 Jan 2014 13:47:24 GMT

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

Re: How to do performance testing in QV

Anonymous — Thu, 02 Jan 2014 13:48:49 GMT

thanks for your responses, Piyush, but i was looking more into calculation time of expressions / objects vs. the load script.

Re: How to do performance testing in QV

Miguel_Angel_Baeyens — Thu, 02 Jan 2014 13:53:57 GMT

Hi,

This content is not publicly available so please refrain uploading files unless you are certain of their public convenience. Rather, point to the link where the document is, so the user can get the most recent issue and download it.

Miguel

Re: How to do performance testing in QV

Anonymous — Thu, 02 Jan 2014 13:56:57 GMT

Hi Miguel, thanks for your great book BTW! any way you can shed some light and give some generic pointers on my question above? I was looking at the forum and books and while there are tons of recommendations and best practices, there are little or no information how to actually benchmark and validate performance of calculations. The QV cache makes it difficult to do real benchmarks and it would be great to hear from pros like you or HIC.

Re: How to do performance testing in QV

Miguel_Angel_Baeyens — Thu, 02 Jan 2014 14:07:43 GMT

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

Re: How to do performance testing in QV

Anonymous — Thu, 02 Jan 2014 14:11:50 GMT

oh I am sorry, Miguel. thanks, I missed that group - i see wealth of information there.

Re: How to do performance testing in QV

Thu, 02 Jan 2014 14:41:24 GMT

Hi,

Just go through qlikview optimizer.qvw. just type on google and you wil get it. there you can analyse lots of things like size and time required for each objects, charts, counts of rows etc. its a very nice document for performance testing.

Reagrds,

Piyush jain.

Re: How to do performance testing in QV

ajaysikharam — Wed, 16 Mar 2022 12:45:32 GMT

I don't see any document here, @Anonymous can you share that to me here.

Thx

Re: How to do performance testing in QV

MarcoWedel — Wed, 16 Mar 2022 21:03:49 GMT

https://community.qlik.com/t5/QlikView-App-Dev/How-to-do-performance-testing-in-QV/m-p/536165#:~:text=This%20content%20is%20not%20publicly%20available%20so%20please%20refrain%20uploading%20files