Performance on QV Desktop different than QV Server

[#1]

Hello Everyone,

I have an application that while browsing in QV Desktop is fine. While that same application with the same data set once published in the server behaves VERY slow...specially when clicking on filters.

Is there anything that would cause this to happen? I have about 120,000 records.

What is the best way to measure performance in the QV Access Point?

Thanks in advance.

[jpapador]

Have you tried different browsers or IE client vs AJAX.  Also could the connection between your server and the endpoint be a slow connection or slowed because of heavy network traffic?  What version of QlikView Server are you running?

[#3]

Hello jpapador,

We have tried IE and Chrome, same result. Client and server is in the same domain and happens at all times, day or night. Server is running QV 11 SR5.

[ToniKautto]

120k records is a fairly small amount of data. So more likely have resources issues or networks issues. 

My guess is that you are not comparing the application on the same machine, which means you might have different resources and background processes. Make sure that you do the comparison on the same machine. 

When accessing server applications, you need to consider the network latency. Try accessing the server on the server machine, that way you eliminate any network issue from the scenario

[Clever_Anjos]

Maybe different clients.

When you access the version on server, are you using Ajax version? Sometimes it appears to be slower

[#6]

We were using Ajax. Downloading Plugin now to see if it makes any difference.

[#7]

Other applications in the same server with more data open and feel fine which i think would rule out network or resources issues.

RDP into server and opening the app has no effect on speed still take over 5 minutes to open certain sheets and when moving from sheet to sheet causes them to over display one on top of another.

[ToniKautto · Accepted solution]

I can agree that the network mostly likely is not a factor in your issue. Resources I would still consider as potential reason for the issue, but more from the point of view that your server application uses more resources than the desktop file.

I would suggest the following fro troubleshooting...

- Use exactly the same file in your server side desktop client as you access from the webclient. This means the distribute QVW, and not the source QVW. This could sow you if the issue is cause by the distribution.

- Compare the CPU and memory consumption when you replicate the issue in webclient and desktop client. Is there any difference in the allocation patterns?

- Use web view in desktop client, and IE as browser. This way your webview and browser uses the same browser engine.

- Check any section access or reduction (task setting). With dynamic or static reduction your server side data might be different than in desktop, which could lead to logical differences.

- Macro support is limited in webclient. Are you using any macros in the application? In AJAX client they would probably not run, and might not apply intended logic.

[#9]

I tried as suggested the IE Plugin and through the plugin the application now behaves the same way as in my desktop.

There is no Macro's in my solution but the solution has a complicated data model to support a section access by Region but still allow an accurate count of employees throughout regions. (It is an HR application and needs to be able to count active employees in the user's region, so it needs all the records to be able to count in case an employee has moved from one region to another).

Maybe this is making AJAX misbehave and the IE Plugin can figure it out properly?

[ToniKautto]

It sounds a bit odd. The data reduction is done on the server side, so a user will get the same datat section regardless of client. My nest guess is that you have massive table objects, and these will be significantly slower in AJAX than IE Plugin, due to that they are handeld as large HTML objects and rendered by the browser.