By a “high” number of records, we usually mean in the millions.

The Scatter factor is a logarithmic scale. Think earthquakes. A magnitude 3 might be noticeable, but it is no cause for alarm. A magnitude 7 knocks down houses.

If done carefully, multi-threaded data dictionary operations can be very fast.