One of our customers has been using a Servoy solution with two users. Recently, we added a third client to the network. All three users are complaining that since the third user was added, the whole system has significantly slowed (minutes to load forms).
All three users are in the same LAN, and one of the three computers is used as a server in another user account on that machine. All three are Macs running 10.10.
I don’t understand how the third user could cause this kind of problem for all three of them, particularly as the third computer has no bearing on the server, and all other network operations appear to work fine…
The top few operations of the performance data are attached as a screenshot, and I can’t see anything of any significance causing a problem in the SQL (nothing more than 9ms).
Servoy Server seems to have been restarted recently, however the computer its-self has not…
The solution does not have many calculations, and nothing has changed apart from the new user since their report a few weeks ago that the system was behaving well.
I would be grateful if anyone has any experience of something like this, or a potential thing to look at ?
I know, I wouldn’t normally run Servoy on a user account unless I really had to, but my experience in the few instances where I had to, it didn’t affect things like this (I think one or two users shouldn’t cause a problem?)
I will look at the trace of the server when I can…
There is no problem on the server CPU, Java permanently 0.1% CPU. Postgres 0.0%cpu during the remote client connections…
Network performance on server seems to be fine (I can remotely view screen and there is no performance problem) however the server is wireless (I suspect that this is the cause).
Performance data on the server shows that everything less than 10ms. Zero runaway calculations or multi layer relations. Calculations have been reduced wherever possible.
ALL remote clients are glacially slow, minutes or at least a minute to scroll through records, switch forms etc.
However client running locally on server is perfectly normal.
This solution is one which I have supplied to other customers in exactly the same form, and it works fine elsewhere.
Also, to be fair, I wouldn’t even know whether it was in trace mode or not as the console and the Servoy smart client window are permanently grey… I have to keep quitting and starting Servoy to get grey screens to disappear…
Often I’ll be working and find a weird behaviour that I’ve never seen before. I start fixing that and it opens up a whole farm of other weird behaviour that I have never seen before… They’re doing it to mess with me, right?