You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

what are disadvantages of having multiple databases in one application?

edited Aug 2, 2018 2:36AM in Essbase 10 comments

Summary

what are disadvantages of having multiple databases in one application?

Content

Happy Spring everyone.

In Essbase BSO  most applications have only one database.  Is there any reason why we can't have multiple databases?

What are disadvantages of having multiple databases in one application?

I'm only interested in disadvantages in terms of sharing memory and performance.

We are on Linux and have lots of memory. We want to have 5 databases (db) under one app and assign  1GB of RAM to Data Cache and 900 MB of RAM to Index cache for each of the db. Would they perform as well as having 5 apps with 1 database each with1GB Data Cache, 900MB Index cache?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!