Beware the new fetch feature of SQL 2012. RBAR in disguise?
Although SQL Server 2012 new Paging function is intuitive for the purpose of paging a data set, it comes at a cost for large volume of data. The Top Batching and Direct ID Batching perform significantly better under similar circumstances, i.e. simple Source Data with continuous ID.
Paging Function Performance in SQL Server 2012 | Ms SQL Girl
There is also another bug around identity columns skipping increments after a SQL restart that might affect how paging functions in SQL 2012. Be sure to test any applications doing server-side paging!
No comments:
Post a Comment