Hello everyone, my question is related to the configuration of the service on Anywhere 17. By having 20 databases, is there a difference in server performance if I define a single service that contains all the databases against sharing them in several services?

Thanks a lot!

asked 13 Jan, 20:02

JAValdez's gravatar image

JAValdez
457
accept rate: 0%


Here's an older discussion on that topic with different point of views.

To add a few points:

  • One server instance can better share its cache between many databases whereas 20 different server instances must restrict theis cache usage or will compete for RAM.
  • Each server instance will need its own port, whereas one server can use the default one.
  • With v16 and above, a former disadvantage of one single server instance is gone: A database assertion failure within one database does not affect other databases on the same instance. With v12 and below, it would stop all databases.

But in my understanding, this is not only a question of performance but with general maintenace. Say, you plan to upgrade the system. Is is fine for you to upgrade all databases at the same time? If not, several server instances might be more appropriate.

permanent link

answered 14 Jan, 03:56

Volker%20Barth's gravatar image

Volker Barth
36.1k342501749
accept rate: 34%

Just to add:

For v16, this is also mentioned in the Online Help as part of the FAQ:

(14 Jan, 10:24) Volker Barth

Thanks Volker for your help!. I have read the links you recommended and I discuss it with my colleagues.

(14 Jan, 11:56) JAValdez
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×164
×39
×31

question asked: 13 Jan, 20:02

question was seen: 170 times

last updated: 14 Jan, 11:56