Hi all, I'm doing a project in 1.5 where we use multiple subdomains, each having a strong relation to the mother site. I was thinking of using a single database. Each sudomain would have a lot of common pages which could be built in identical ways. The selection of relevant information for the subdomain would be done on the basis of an identifier. For the identifier I could use Metadata. Every subdomain could have its own Metadata keyword that is automatically associated with every ContentItem created for that subdomain. The advantage would that I could easily create associative links from an article in subdomain 1 to an article in subdomain 2 using a metadatakeywordobjectfind. However, I'm a little concerned about performance because everything for a subdomain would have to be selected this way. Since it's all one database, you have one pile of press releases, one pile of articles, etc. Another approach could to create a default searchable property for each ContentObjectType that allows me to automatically add subdomain information. This way I could create speedy SQL-queries to select relevant stuff. Of course, this goes around the regular Spectra abstraction layer and it would mean I would have to do it for everything on the site. If I use seperate databases I expect to gain in performance and stay in the Spectra abstraction environment, because I wouldn't have to use the subdomain metadata approach. Then, of course, I wouldn't be able to create associative links to other subdomains very easily. Does anyone have any experience/ideas regarding this subject? Kind regards, Marc Schipperheyn <theFactor.e> Premium Partner for Macromedia The future is technological, but it will not be a world of gray steel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
