Page 1 of 1

in-memory Repository server

PostPosted: Thu Sep 24, 2020 8:12 am
by jeffrey.vandenhondel
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 3385 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?

Re: in-memory Repository server

PostPosted: Thu Sep 24, 2020 9:15 am
by ROCLASI
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? :)

Re: in-memory Repository server

PostPosted: Thu Sep 24, 2020 10:48 am
by jeffrey.vandenhondel
Yeah i forgot to ask a question :P

Re: in-memory Repository server

PostPosted: Thu Sep 24, 2020 11:19 am
by jcompagner
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.

Re: in-memory Repository server

PostPosted: Thu Sep 24, 2020 11:25 am
by jeffrey.vandenhondel
Ok thank you. Then we will look further