4 ms·

I was mostly in agreement. I suppose it depends on the scale of the data. Fitting 1000 short rows in memory is something I'd expect anyone to know off the top

• woko 5y ago
  It is clear by the mention of "several orders of magnitude" that we are talking about a database which fits in a few MB of disk space on a machine with a few GB of RAM. If the interviewee has never worked with a database which would fit in the memory of the machine, and if the company only deals with such databases, then it is clear that it was not a good fit. Failing the interview does not mean that the interviewee is bad, just that they don't know how to count that low, and thus were not the person for the job.
  • Dylan16807 5y ago
    > If the interviewee has never worked with a database which would fit in the memory of the machine, and if the company only deals with such databases, then it is clear that it was not a good fit. Why? That's not clear at all to me. Most of the job is the same, and the parts that are different are themselves mostly removing steps that aren't needed at a smaller scale.
• Dylan16807 5y ago
  Even then, it's good to stop and consider if those 1000 rows truly represent the full data set you need to run this on.