9 Replies Latest reply: May 20, 2015 6:03 PM by Toni Kautto RSS

    Performance on QV Desktop different than QV Server

    Enrique Teran

      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.

        • Re: Performance on QV Desktop different than QV Server
          Jared Papador

          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?

          • Re: Performance on QV Desktop different than QV Server
            Enrique Teran

            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.

              • Re: Performance on QV Desktop different than QV Server
                Toni Kautto

                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

                  • Re: Performance on QV Desktop different than QV Server
                    Enrique Teran

                    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.

                      • Re: Performance on QV Desktop different than QV Server
                        Toni Kautto

                        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.

                          • Re: Performance on QV Desktop different than QV Server
                            Enrique Teran

                            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?

                    • Re: Performance on QV Desktop different than QV Server
                      Clever Anjos

                      Maybe different clients.

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