SharePoint 2007: Manage large lists for better performance

Here's a link to the post I wrote a while ago. It's applicable to SharePoint 2007 moreso than SharePoint 2010, but you might find it an interesting read nonetheless.

https://sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx?ID=162

Dina