A few months ago we had a workshop on MOSS from our ADC, and one of the topics he talked about was the performance in retrieving list items. This is so important for the performance of a website, so when I found the post from Waldek Mastykarz on the same subject I just had to highlight it.
Just a quick peek, the methods tested were:
- SPQuery on the list instance
- GetItemById(int) method
- SPSiteDataQuery on the parent Web
- SPSiteDataQuery on the parent Web passing the List ID (using the SPSiteDataQuery.Lists Property)
Waldek then explains each approach and event illustrates graphically the differences . . .