Stacking Code

I've been flirting with the idea of storing the deep zoom images of a Pivot collection in a database as part of a solution for dynamically generating collections on the fly. To do that I need to know how large each image can get in bytes. Sounds like a job for PowerShell.

Using an already generated Pivot collection I ran the following script to find the average, maximum and minimum file sizes of the images at each zoom level.

$images = Get-ChildItem -Filter 0_0.png -Recurse
"0 stats"
$images | where { $_.FullName -like "*Images\*_files\0\0_0.png" } | measure -Average -Maximum -Minimum -Property Length
"1 stats"
$images | where { $_.FullName -like "*Images\*_files\1\0_0.png" } | measure -Average -Maximum -Minimum -Property Length
# and so on...

All the images are retrieved and stored in the $images variable. They're then filtered with a pipe using where and like, and then crunched with another pipe using measure.

The end result is something like this...

0 stats
Count    : 37666
Average  : 117.089709552381
Sum      :
Maximum  : 163
Minimum  : 106
Property : Length

1 stats
Count    : 37666
Average  : 129.242048531832
Sum      :
Maximum  : 170
Minimum  : 113
Property : Length

This will help me roughly determine the column sizes if I go down this road. I love how easy it is to do set based operations in PowerShell.