Sharepoint WebParts

Question

I just finished my first web Part for Sharepoint WSS 3.0 and I'm very excited.
What it does is that just makes a connection to the TFS (team foundation) to get the OPEN and FIXED bugs by Sprint (We actually use SCRUM agile Process). Then takes both values (open & fixed) and puts them in a sharepoint list. A chart is fed with that list (using codeplex's web parts).

In the other side the web part retrieves information about the current team names from the Project Server, it follows the same procedure but it just feeds a Sharepoint list.

Any recommendations on performance or anything else would be much appreciated.

PD. i will set this as a community wiki 'cause there is no correct or wrong answer, just waiting for your feedback =D.

Answer 1

I'm a bit confused... Your webpart populates the list with values from TFS?

If you use a webpart, the list is populated only when someone visits the page and EVERYTIME someone visits the page.

Wouldn't you want to populate your SharePoint list using a console application or a SharePoint timer job that runs every so often?

Answer 2

To go a step further. Use federated search. In SharePoint (MOSS) you can specify locations (content sources) for the search service to index. This data will then be queryable in your sites. Using either custom scopes / customized search queries you can retieve data and then filter / display it on your sites.