Performance issues with Servoy

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

Performance issues with Servoy

Postby wjlopez » Wed Nov 12, 2014 3:34 am

Hi everyone! We’re having a performance issue with Servoy and I’d really appreciate your input. We don’t have this issue when the database and application server run in the same box.

The following is an environment in which we encounter this problem:

application server is running on host and database is running on virtual servers on the same physical server with the following configuration:
* Oracle virtual box (Date base): 4GB RAM, 2 cores Cpu Xeon 2.00 GHz, OS Windows server 2007, Oracle 11G R2.0.3?
* Servoy App: 16GB RAM, 2 cores Cpu Xeon 2.00 GHz, OS Windows Server 2008 R2 Standard, Java version: Java Standrard edition V7, update 25, (build 1.7.0_25-b16) and servoy Version: 7.4.1 - build 2028

Virtual machines runs on: Oracle VM VirtualBox, Version: 4.3.10

The application takes up to 3 minutes to show the start menu (application uses de DBTREView to display the menu) , then, after clicking an option it takes up to a minute to display it.

I hope I explained myself adequately. Thanks in advance.
Last edited by wjlopez on Wed Nov 12, 2014 6:37 pm, edited 1 time in total.
wjlopez
 
Posts: 7
Joined: Wed Nov 12, 2014 3:25 am

Re: Wilson Lopez

Postby ROCLASI » Wed Nov 12, 2014 10:16 am

Hi Wilson,

How far are these 2 servers apart from each other? Are they in the same rack or are they really in 2 different geographical locations?
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Wilson Lopez

Postby deezzub » Wed Nov 12, 2014 10:50 am

I think the thread subject don't reflect your question. ;)
deezzub
 
Posts: 328
Joined: Tue May 28, 2013 3:02 pm
Location: Oldenburg, Germany

Re: Wilson Lopez

Postby wjlopez » Wed Nov 12, 2014 6:47 pm

deezzub wrote:I think the thread subject don't reflect your question. ;)



hahaha thanks!
wjlopez
 
Posts: 7
Joined: Wed Nov 12, 2014 3:25 am

Re: Wilson Lopez

Postby wjlopez » Wed Nov 12, 2014 6:49 pm

ROCLASI wrote:Hi Wilson,

How far are these 2 servers apart from each other? Are they in the same rack or are they really in 2 different geographical locations?


Thanks for answering, I updated the question with more detail.
wjlopez
 
Posts: 7
Joined: Wed Nov 12, 2014 3:25 am

Re: Performance issues with Servoy

Postby wjlopez » Wed Nov 12, 2014 6:59 pm

Good news, I have some progress, here it is in case it helps anyone. Changing the following setting in Java console dramatically improved the time it took to start up.. now I have the issue with loading of the DBTREEview menu takes 7 to 11 seconds
Attachments
img.png
img.png (53.7 KiB) Viewed 4668 times
wjlopez
 
Posts: 7
Joined: Wed Nov 12, 2014 3:25 am

Re: Performance issues with Servoy

Postby jcompagner » Mon Dec 01, 2014 11:15 am

i don't get why that would have affect your smart client performance when moving the database and app server from each other.

Because thats purely a client question. So it doesn't matter how the server is configured, the client wants to check all the certificates before using them
And if you use a lot different of 3th party plugins then you have a lot of different certificates. For this it is better to sign everything your self with 1 certificate (your own) then it should go faster.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet


Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 3 guests