Fixed
Pinned fields
Click on the next to a field label to start pinning.
Details
Components
Assignee
Gavin HallidayGavin HallidayReporter
Gavin HallidayGavin HallidayPriority
Not specifiedFix versions
Details
Details
Components
Assignee
Gavin Halliday
Gavin HallidayReporter
Gavin Halliday
Gavin HallidayPriority
Fix versions
Created June 8, 2015 at 10:50 AM
Updated November 27, 2015 at 10:23 AM
Resolved November 25, 2015 at 2:53 PM
If rows cover a large address space, and the rows are being released in a random order (e.g., following a sort), a significant proportion of the time can be spent while the cpu is stalled waiting for the pages to get into the level3 cache.
Disposing of the rows in blocks on multiple threads mitigates much of the problem.
A first experiment applying this to 280M rows, which occupied ~30Gb of memory cut the time to dispose from about 35s to 5-10s.