in-memory Repository server

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

in-memory Repository server

Postby jeffrey.vandenhondel » Thu Sep 24, 2020 8:12 am

We have some performance difference between our production env and our acceptance/develop server.
They only difference between these servers is that production uses postgres for the repository and acc/dev uses hsqldb for the repository.

Screenshot 2020-09-24 at 08.09.46.png
Screenshot 2020-09-24 at 08.09.46.png (146.23 KiB) Viewed 3333 times


We use a active solution aka war deployment.

EDIT:
Can it be that the hsqldb connect repository has negative effect on the overhall performance?
Last edited by jeffrey.vandenhondel on Thu Sep 24, 2020 10:45 am, edited 1 time in total.
jeffrey.vandenhondel
 
Posts: 36
Joined: Thu Jul 28, 2016 9:05 am

Re: in-memory Repository server

Postby ROCLASI » Thu Sep 24, 2020 9:15 am

jeffrey.vandenhondel wrote:We have some performance difference between our production env and our acceptance/develop server.


Can you elaborate?
Also, was there a question? :)
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: in-memory Repository server

Postby jeffrey.vandenhondel » Thu Sep 24, 2020 10:48 am

Yeah i forgot to ask a question :P
jeffrey.vandenhondel
 
Posts: 36
Joined: Thu Jul 28, 2016 9:05 am

Re: in-memory Repository server

Postby jcompagner » Thu Sep 24, 2020 11:19 am

jeffrey.vandenhondel wrote:Can it be that the hsqldb connect repository has negative effect on the overhall performance?


i would expect the opposite. that hsql which is purely in memory in he same vm without that it has to go over a network is way faster.

and if you use a active solution in side a war then the repository is also not that much used, its just for loading column info once.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: in-memory Repository server

Postby jeffrey.vandenhondel » Thu Sep 24, 2020 11:25 am

Ok thank you. Then we will look further
jeffrey.vandenhondel
 
Posts: 36
Joined: Thu Jul 28, 2016 9:05 am


Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 6 guests