On Wed, 5 Apr 2000, Ron Parker wrote: > Is it accurate to say that increasing numbers of persistent connections to > databases will eventually have a detrimental effect on database > performance? If the answer is yes, then is it accurate to say > that Midgard's use of one database is intended to preserve performance? I have no solid numbers but I do think that if you're going to serve multiple clients (I tested with 10) your database connections are going to go through the roof. If 30 handler processes are active (and that isn't much I think) you have 300 DB connections going. The other reason was that I wanted to share the admin site among clients: preserve DB space, single point of maintenance. > The inherent nature of many persistent database connections eventually has > a negative effect on performance. The Midgard strategy for preserving > database perfomance is to use one database to manage all the elements > and content for many websites. Of course this creates the challange of > preventing the owner of a site from viewing or hyjacking the contents of Hosts > that do not belong to them. I wouldn't go as far as to say that Sitegroups is _the_ Midgard way to solve this. SG is one, multiple DBs is another, and you can certainly get a decent solution using the standard access control mechanism. Where the standard AC mechanism falls short IMO is that is has just one global pool of users. No data can be confidential amongst clients. Sitegroups (and multiDB) solves this by separating their 'address space'. > Considering that Bill G. owns IJustLost$14billion.com and > StillGotMoreThanYou.com, obviously he must have administrative privelages > for those Hosts while it's imperative that he is denied read and write > access to antitrust.com while useing the Midgard administration > tools. SiteGroups prevents Bill from accessing information and elements > which he doesn't own while allowing him to administrate one or all the > sites which he has access to. *grin* I'm fairly sure you can come up with, uh, more generic examples ;) Emile -- This is The Midgard Project's mailing list. For more information, please visit the project's web site at http://www.midgard-project.org To unsubscribe the list, send an empty email message to address [EMAIL PROTECTED]
