Performance issues with Servoy

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.

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?

I think the thread subject don’t reflect your question. ;)

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

hahaha thanks!

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

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

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.