mlbauer (12/23/2010)
All queries will take twice the time for twice the data.
Not really true and "It Depends" pevails a whole lot in that area. Partitioned tables can really help in that area as can properly written code and proper indexing as well as a nice solid database design and effective/regular maintenance of the database.
--Jeff Moden
Change is inevitable... Change for the better is not.