topic Re: Performance Issues in QlikView

Performance Issues

bmensing — Wed, 25 Nov 2020 16:16:04 GMT

Hello there,

i've created a simple data model with only one table. In the app i've only got a straight table object with

one expression and five dimensions. By Scrolling through the data it's slighty stuttering.

Whenever i resize the straight table object, so let's say that there are only a few lines visible without Scrolling - it runs

much better...

I've checked the proberties of the document and the straight table is only using 358 KB... any ideas?

Re: Performance Issues

Anil_Babu_Samineni — Wed, 19 Jul 2017 14:15:25 GMT

Questions from my end

1) What is the file size where you load?

2) How many records are there in your straight table?

3) Looks like you load direct from flat file. But, try to STORE that directory to qvd and load again then check in UI

Re: Performance Issues

bmensing — Wed, 19 Jul 2017 14:23:33 GMT

1) 34 MB

2) 200

3) i am loading out of a .qvw - File

as i said i am getting good results when resizing the object...

Re: Performance Issues

Anil_Babu_Samineni — Wed, 19 Jul 2017 14:26:33 GMT

I've tested now in my application, The moment you said is 200 Records. I wonder, even what was the debug we need to look. I am not that expertise in? May be marcus_sommer‌ stevedark‌ can explain as we are to

Re: Performance Issues

bmensing — Wed, 19 Jul 2017 14:31:29 GMT

of course its hard to get an out-of-the-box solution... but maybe someone can explain

why a small-sized object works smooth instead of a large-sized object...

Re: Performance Issues

stevedark — Wed, 19 Jul 2017 14:38:51 GMT

Are you experiencing this in the browser?

If so, what you are seeing is a symptom of how QlikView only sends the data that the user can see to them when the object is first rendered. When they scroll it then sends the next bit of data - causing a stutter. This is obviously essential when you have thousands of rows. Unfortunately even when there is only a relatively small amount of data you may still see a stutter.

Re: Performance Issues

marcus_sommer — Wed, 19 Jul 2017 14:53:08 GMT

I wouldn't really expect any performance-issues by this app-size and number of records within the table. Whereby are you using any calculated dimensions or any aggr() or nested if-loops there? Any functions like now() or dimension-groups or variables in use or maybe conditions in dimensions/expressions?

- Marcus

Re: Performance Issues

bmensing — Wed, 19 Jul 2017 14:57:16 GMT

its in the browser but although in the development Environment... after reducing the Dimension

to let's say only 2 or 3 ... its getting better...

Re: Performance Issues

bmensing — Wed, 19 Jul 2017 15:07:09 GMT

only sum() with set expression... and no calculated dimensions.. when reducing the quantity of the dimension its getting better... but why? all fields belong to the same .qvd

Re: Performance Issues

marcus_sommer — Wed, 19 Jul 2017 15:21:21 GMT

Actually I couldn't remember such behaviour with quite small tables. Do you experience this only with this table respectively application or are there other ones, too? Another potential issue - is the server-release and the release from the development desktop client the same?

- Marcus

Re: Performance Issues

stevedark — Thu, 20 Jul 2017 10:02:00 GMT

I came across some performance issues in an app someone else had created, and they had put now() into a variable. Any time that variable appeared on a sheet the whole server trembled...

Re: Performance Issues

marcus_sommer — Thu, 20 Jul 2017 10:24:07 GMT

Yes, you are right - now() is a performance-killer.

Re: Performance Issues

shiveshsingh — Thu, 20 Jul 2017 10:41:55 GMT

Is your data getting refreshed daily?

Are you using resident load? You can call from QVD instead of calling from resident if u are using that.

Re: Performance Issues

marchoctober — Thu, 20 Jul 2017 13:57:10 GMT

Hi Bernd, share in here your SET parameters in expression. Share the number of ROWs of your data not size in MB. What browser are you using? IE? Try another one.

Are you using virtual environment server?

Are you using virtual environment at client side?

Is it working good in QV Desktop? How much RAM it takes when you run an app on Desktop? How much do you have on client side RAM available?