Posted by
Andrew Sykes on
Oct 11, 2005; 11:15am
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-Application-for-industry-regulator-tp136104p136113.html
Ian,
We've had to make similar decisions in the past, just to supplement
David's response, we were able to actually run multiple webapps for
different companies within a single OFBiz instance, each connecting to a
separate DB.
Of course with the large number of companies involved this may not be a
practical solution on it's own, but the advantage of course is that
setting up multiple instances is fairly straight forward if the apps are
already separated. You also have the added advantage of being able to
shift individual apps between different instances to help tune
performance, which is a far more frugal setup than a separate instance
for each company.
That being said, we made this choice on the basis that the number of
companies was never likely to exceed about 20. If I'd been faced with
100 companies, I suspect I would have opted for David's suggestion :-)
One more thing I noticed, in your second solution scenario, you describe
a multi instance setup with a separate instance for potentially shared
data, perhaps you could do this the other way around, i.e. have a
separate instance serving USER_LOGIN and such like data using multiple
delegator/DBs in a single instance as mentioned above and a second
instance for your shared data...
I hope that's useful...
--
Andrew Sykes <
[hidden email]>
Sykes Development Ltd
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users