Design Decisions

polo

Hi,

We are implementing new website using teamsite templating. To make best design decision we need some reference material / suggestions.
If you know about any documentation already written on this please give us the links.

Thanks and Regards,
Pankaj

Hamjam

In general, performance is a function of database design, indexing strategy, software built around the underlying database, and contention on the resources and the infrastructure used. From your question it was hard to tell whether the portal would be integrated into your existing environment. Some of the ways the integration could be performed would be:

Would the database supporting this portal be co-located on the same server as your search engines?


Would the portal application maybe leverage the same underlying database structures?


Would the portal application be linked to the search engine application database using linked servers?

If any of these basic scenarios existed, then the questions I would pose would be as follows:

What is the performance on the existing search engine today? Is it acceptable or not?


What sort of contention do you see today on your search engine?


What sort of contention do you see when you run on the portal engine?


Are the contention resources related or are they ones that could be eliminated by putting objects onto different disks, adding CPUs, memory, etc.?


What sort of data is being pulled by the search engine vs the portal?


How are you trying to get at the data via views, direct joins etc.?

Maybe in order to reduce contention and maximize performance it will be neccessary to create some derived tables which are updated on a specified frequency to eliminate unneccessary contention. How update intensive is the portal engine , if there is a lot, you may have concurrent usage issues there.

Not sure if that helps, but good luck.