1 of 1 people found this helpful
Let's start with a trivial case, US states. There are 50 of them. Let's say that you've got a dozen or so solutions that all use the same data. Can you have a common states database that is referred to by all those solutions that is not, itself, shared (and thus using up one of the 125 slots for sharing databases)?
Yes and no. Such "library" databases are fairly common. You just link to it from every solution that needs it as an External Data Source.
But - big But - the 125 file limit isn't on sharing. It's on hosting. If the file is being hosted by Server, it'll consume a slot. (And I would NOT recommend trying to do this with a local, non-hosted file.) So even if it doesn't show up in Open Remote, it's still eating footprint.
So if you're trying to save hosting capacity, then no, this wouldn't work. But remember, you can have multiple tables per file, so you could easily enough include such a library table inside one of the other solutions and reference it from there. In that case, you gain the benefit of only having one copy of the necessary library (which is a very good thing - multiple sets of books are Bad), and you don't consume any extra hosting space.
Thanks, you've given me my capacity planning answer.