Servoy slowdown since new user added

Discuss all problems you have with Servoy here. It might help to mention the Servoy version and Operating System version you are using

Servoy slowdown since new user added

Postby bevil » Wed Jan 28, 2015 4:43 pm

Hi all

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 ?

-Bevil
bevil
 
Posts: 133
Joined: Thu Oct 18, 2012 7:31 pm

Re: Servoy slowdown since new user added

Postby Harjo » Thu Jan 29, 2015 6:06 pm

By having such little info, it is almost impossible to say anything, what makes sense....

My first point is, that I should never run a Servoy server, on somebody's desktop.... :?

some allround checks you could do....
1. Look at your servoy-admin page, performance panel..
2. Set the client in debug: CTRL ALT SHIFT T and let the java console open, to see what happens in the background.
3. Look at your CPU or memory on the server.
4. Look into Servoy log files.
5. Check your network (hardware firewall?)
etc.etc.
Harjo Kompagnie
Direct ICT / Servoy Hosting / ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
User avatar
Harjo
 
Posts: 4269
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Servoy slowdown since new user added

Postby bevil » Thu Jan 29, 2015 9:26 pm

Thank you Harjo

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...

Sorry for being such a slacker. :(
bevil
 
Posts: 133
Joined: Thu Oct 18, 2012 7:31 pm

Re: Servoy slowdown since new user added

Postby bevil » Sun Feb 01, 2015 3:11 pm

I have now done a bit more testing on this issue..

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.
bevil
 
Posts: 133
Joined: Thu Oct 18, 2012 7:31 pm

Re: Servoy slowdown since new user added

Postby Harjo » Sun Feb 01, 2015 4:28 pm

And,what does the cliënt debug mode tell you?
Harjo Kompagnie
Direct ICT / Servoy Hosting / ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
User avatar
Harjo
 
Posts: 4269
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Servoy slowdown since new user added

Postby bevil » Sun Feb 01, 2015 4:46 pm

Hey Harjo

I can't get the trace to start. CMD ALT SHIFT T does nothing with console running, and in client, on my Mac, or my PC, or client's Mac remotely.

:(
bevil
 
Posts: 133
Joined: Thu Oct 18, 2012 7:31 pm

Re: Servoy slowdown since new user added

Postby Harjo » Sun Feb 01, 2015 6:47 pm

It's CTRL. Not CMD, slacker.. [WINKING FACE]
Harjo Kompagnie
Direct ICT / Servoy Hosting / ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
User avatar
Harjo
 
Posts: 4269
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Servoy slowdown since new user added

Postby bevil » Sun Feb 01, 2015 6:50 pm

You wouldn't think that my whole career is IT consulting and database development, would you... ? :)
bevil
 
Posts: 133
Joined: Thu Oct 18, 2012 7:31 pm

Re: Servoy slowdown since new user added

Postby bevil » Sun Feb 01, 2015 7:35 pm

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... :(
bevil
 
Posts: 133
Joined: Thu Oct 18, 2012 7:31 pm

Re: Servoy slowdown since new user added

Postby Harjo » Sun Feb 01, 2015 7:47 pm

I think Servoy has build several Bevil bugs, just to nag you ;-)
Harjo Kompagnie
Direct ICT / Servoy Hosting / ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
User avatar
Harjo
 
Posts: 4269
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Servoy slowdown since new user added

Postby bevil » Sun Feb 01, 2015 8:02 pm

Yeah, I KNEW IT !!!..

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?
bevil
 
Posts: 133
Joined: Thu Oct 18, 2012 7:31 pm

Re: Servoy slowdown since new user added

Postby Harjo » Sun Feb 01, 2015 8:33 pm

Yes, they even put in the release notes, because they know you never read them LOL :-)
Harjo Kompagnie
Direct ICT / Servoy Hosting / ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
User avatar
Harjo
 
Posts: 4269
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Servoy slowdown since new user added

Postby bevil » Sun Feb 01, 2015 9:06 pm

Release notes? What is this?
bevil
 
Posts: 133
Joined: Thu Oct 18, 2012 7:31 pm


Return to Discuss possible Issues and Bugs

Who is online

Users browsing this forum: No registered users and 2 guests