Tuesday, August 18, 2020

Powershell Fastest and Efficient way to read huge csv file

$row_count = 0 
Get-Content '.\big_file_name_with_path.csv' -ReadCount 2000 | foreach { $row_count += $_.count }
$row_count

at
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Find the Subtasks That Did Not Execute Leetcode

 with recursive CTE as ( SELECT task_id,subtasks_count,1 as result FROM Tasks UNION ALL SELECT CTE.task_id,subtasks_count,result+1 FROM CTE ...