Post reply

Scaling out

  • July 17, 2007 at 6:05 am

    #117777

    Hi everyone,

    I have an extremely large table in my database (SQL Server 2000). I am considering dividing the table using horizontal partitioning (partitioned views). What are the drawbacks of using such an approach other than the design overhead? Will this approach increase the performance of my queries enough to justify the extra work?

  • July 18, 2007 at 8:46 am

    #720387

    Typical Answer:  It depends. 

    Seriously though, if your query patterns normally restrict the data such that only smaller pieces of the table will be needed (one or perhaps a few partitions) then yes, you will see significant performance increases.  If you usually need to scan through all the data in the table you will only see minor improvements in throughput (due to more efficient parallel asynchronous reading - and this only if you have sufficient CPU cores [not hyperthreaded ones] to benefit).

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply