4 ms·

I also came in to comment on this excerpt that failing someone over something so trivial is literally insane.

blueplanet200 5y ago
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 of their head just works. It really depends on the specifics of the question and the seniority of the role...
- 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.
robocat 5y ago
My guess is that the interviewer was using the question to select for people who choose appropriate solutions. Someone who suggests a complex highly scalable replicated database architecture for a 5MB database is very likely an unsuitable candidate. Also the interviewer could be looking for whether someone asks the right questions to be able to suggest an appropriate solution, rather than someone who doesn’t ask, jumps to conclusions, and makes poor assumptions. Once you have worked with one architectinaut that builds baroque solutions, you make sure you don’t employ that kind of person. Anyone can design something complex, it takes talent to simplify everything properly.

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 of their head just works. It really depends on the specifics of the question and the seniority of the role...

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.

robocat 5y ago

My guess is that the interviewer was using the question to select for people who choose appropriate solutions. Someone who suggests a complex highly scalable replicated database architecture for a 5MB database is very likely an unsuitable candidate. Also the interviewer could be looking for whether someone asks the right questions to be able to suggest an appropriate solution, rather than someone who doesn’t ask, jumps to conclusions, and makes poor assumptions. Once you have worked with one architectinaut that builds baroque solutions, you make sure you don’t employ that kind of person. Anyone can design something complex, it takes talent to simplify everything properly.