search

microsoft / sql-server-language-extensions

language-extensions-sqlserver
Other
106 stars 43 forks source link

Python `restore-packages.cmd` -> Extract Boost.zip is extremely slow on Windows #52

Closed seantleonard closed 1 month ago

seantleonard commented 3 months ago

PowerShell which extracts Boost boost_1_79_0.zip (187MB) is extremely slow. -> ~18minutes on the pipelines. https://github.com/microsoft/sql-server-language-extensions/blob/fc6a854a0d87dfb6a3c71194f67097792da32299/language-extensions/python/build/windows/restore-packages.cmd#L55

I can replicate slow extraction locally (although faster than pipelines). what works even faster is using 7zip which may actually be pre-installed on pipelines:

"C:\Program Files\7-Zip\7z.exe" e -y -o"C:\dev\download_sf_boost" "C:\dev\download_sf_boost\boost_1_79_0.zip"

This works in a fraction of the time 1-2 minutes.