We're having a strange problem that I would appreciate some thoughts on. We have a semi-large application that tracks transactions. The main table has around 1.3M rows, with twenty or so surrounding tables. When using the IE Plugin to view this, all is well.
However, when it is opened with the Ajax client, the QVS.exe process on the server shoots to 100% CPU usage and after 60 seconds it timeouts. During this time, the web interface is unresponsive if another client tries to use it. After the timeout (or when the user closes the unresponsive browser window) the web interface becomes responsive again after 10-20 seconds.
What could cause this behaviour, and why is the server acting so differently depending on which client is used to access the interface? I don't think our data set is very big at all, so what would happen if it were to grow from here?
Go ahead and open a case with QlikView Support. As always provide as much information as possible since I haven't seen this issue before. The 60 second timeout is a limitation in the OS but from QVS 9.00.7320 (SR2) you are able to control the number of seconds allowed by the idle connection. However it doesn't explain the poor performance you experience in Ajax.
We, too, have noticed a HUGE difference between AJAX and IE Plug-in performance. The IE Plug-in app responds withing 1-2 seconds and the AJAX app takes upwards of 30-45 seconds to render a selection. Are there settings we can adjust to improve the performance of the AJAX app? We're using AJAX for our clients that access their apps via the web because we don't have to mess with getting their network folks to open up ports and allow the Active X download and installation.
I am experiencing this AJAX client performance challenges in the recent QlikView 10 SR2 version. However, the application is blazing fast in IE client. Is there any solution for this issue? Please find below our environment details.
Processor: Intel(R) Xeon(R) CPU X5650 @ 2.67GHz 2.67GHz (6 Processors)