What the documentation leaves out.

SetLoadFields in AL: When It Helps, and When It Quietly Makes Things Worse

Partial records can cut a slow loop down dramatically, but used carelessly they add a second database round trip per row. Here is how to tell the two apart.