I have been having some fun with Dynamic updates on AJAX and on QVP alike, I have come to some interesting findings and wanted to know if any of you have had the same problems and have found some solutions for it.
using a test server with the following specs:
Intel® Xeon® CPU E5-2686 v4
We have done the tests below and obtained worrying results:
Multiple users execute an Update dynamic update at the same time
The application freezes for both users and no other users can provide Dynamic updates. To resolve this we have to restart the services
When someone logs in and a server side exports precedes it by a few seconds
The export is successful but the user is unable to log in and a next dynamic update is unable to fire of.
When someone logs in and at the same time someone executes an update dynamic update
the dynamic update fails and the user is unable to log in, no other user is able to use dynamic updates after this point.
We have been searching quite a lot to find the root cause of it but we think it is in the lines of the ram model freezing. It seems Com objects and CPU power also has some influence into this.
Dynamic Update is an old feature that Qlik never got to work very well. It is buggy and poorly documented. It is not meant as a multi-user feature at all - in the documentation it is clearly stated that it should only be used by administrators and as a single user.