Extracting only the lines with "[Result]" in them into new file (using grep) takes about 3 seconds.
Importing that into a local Postgres database on my laptop takes about 1.5 seconds.
Then running a simple:
select result, count(*) from results group by result;
So the total process took only 5 seconds (and now I can run much more aggregation queries on that)
Extracting only the lines with "[Result]" in them into new file (using grep) takes about 3 seconds.
Importing that into a local Postgres database on my laptop takes about 1.5 seconds.
Then running a simple:
Takes about 0.5 seconds.So the total process took only 5 seconds (and now I can run much more aggregation queries on that)