>I have been spending a lot of time recently working with SPList objects in the SharePoint object model for both SharePoint 2003 and 2007.
I am impressed how well the object model performs and used a number of methods to enumerate the SPLists, this started using the for-each loop against the SPListItem Collection and then moved to using CAML queries and the SPQuery object (this is steeper learning curve but performance is better).
However I have wondered how performance is impacted when the size of the lists grow. Anyway Steve Peschka has done a great job looking into the performance of the SPList object and also taught me some new methods to get the data.
Good work Steve
http://go.microsoft.com/fwlink/?LinkId=95450&clcid=0x409