can we kind of break this down a bit, I'm kind of PowerShell dumb/noob.  

When the Get-VMHost command gets piped into the Get-AdvancedSettings command is that executed for each host like a for next loop, or are the values all cached in something like an array and executed all at once after all vmhosts are contacted?