Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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)



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: