René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Import-CSV has very high filesize-to-memory consumption ratio of around 50","articleBody":"Steps to reproduce\r\n------------------\r\nImporting a 150 MB CSV file with 50k rows, 700 columns and 5 +/- 3 characters per entry results in a memory consumption of 7GB of the PowerShell process. This is a ratio of around 50 when compared to the file size. I have seen this ratio also with a similar file of smaller size (1.5MB) and therefore think this is a more generic issue not specific to the CSV file structure itself.\r\n```powershell\r\n$csv = Import-Csv $pathToCsvFiile\r\n```\r\n\r\nNote that this does not happen if I do not assign to a variable or pipe to `Out-Null`\r\n\r\nExpected behavior\r\n-----------------\r\n\r\nFilesize to memory ratio is reasonable (around 10)\r\n\r\nActual behavior\r\n---------------\r\n\r\nFilesize to memory ratio is around 50\r\n\r\nEnvironment data\r\n----------------\r\n\r\nLatest daily build and RC1\r\n\r\n```powershell\r\n\u003e $PSVersionTable\r\nName                           Value\r\n----                           -----\r\nPSVersion                      6.1.0-preview.761\r\nPSEdition                      Core\r\nGitCommitId                    6.1.0-preview.761\r\nOS                             Microsoft Windows 6.3.9600\r\nPlatform                       Win32NT\r\nPSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}\r\nPSRemotingProtocolVersion      2.3\r\nSerializationVersion           1.1.0.1\r\nWSManStackVersion              3.0\r\n\r\n\r\nName                           Value\r\n----                           -----\r\nPSVersion                      6.1.0-rc.1\r\nPSEdition                      Core\r\nGitCommitId                    6.1.0-rc.1\r\nOS                             Microsoft Windows 6.3.9600\r\nPlatform                       Win32NT\r\nPSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}\r\nPSRemotingProtocolVersion      2.3\r\nSerializationVersion           1.1.0.1\r\nWSManStackVersion              3.0\r\n\r\n\r\n```\r\n","author":{"url":"https://github.com/bergmeister","@type":"Person","name":"bergmeister"},"datePublished":"2018-08-22T13:25:49.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":22},"url":"https://github.com/7603/PowerShell/issues/7603"}