Performance Characteristics of using Large MOSS Lists
Steve has published another excellent white paper on the performance characteristics of using large SharePoint lists "Working with Large Lists in Office SharePoint Server 2007". The whitepaper is definitely worth a read.
</steve>