3 ms·
So there are 2197188 games in that file. Extracting only the lines with "[Result]" in them into new file (using grep) takes about 3 seconds. Importing that in
by hans_castorp 8y ago
So there are 2197188 games in that file.
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;
Takes about 0.5 seconds.
So the total process took only 5 seconds (and now I can run much more aggregation queries on that)