Very interesting and useful info, thanks for sharing freejung.
This site has been having some problems and creating problems for the other sites in the database.
Some of your points like this one didn't occur to me. Seems obvious now the fact that they would all share one database. That seems like a potential mess to clean up if you migrated a single site of the shared core. I can see the sharing of elements could be very useful for similar types of sites, and I do hear what you're saying about having to keep up on your housekeeping or it would become confused.
From your points it sounds like probably if you had related or similar sites that utilize the same add-ons or users etc it would be great, but if you had completely different types of sites on one core it could prove to be more hassle than help when it comes time to update or isolate a problem.
I'm actually in the process of splitting one site off onto a separate core.
From this I would assume it is possible to go from traditional to advanced installs, or back, in order to either separate/join cores or just move the core out of the web access folder. Is that as simple as running the advanced installer when you update and picking a new location for the core or is it much more involved?
Thanks again for the input.