Fragen aus Vorstellungsgesprächen für Software engineer, von Bewerbern geteilt
How should you go about finding a bottleneck at some page at your site? (e.g. one taking too long to load). Then, if it's the database, how to solve that.
Firstly, I would profile it to find the function call taking longer. If it's something about the database I would turn on the full log on pgsql (my choice) and see the query that's taking longer. Then, tackle it individually by creating indexes, denormalizing and such.
The assignment document was poorly described with few contradicting statements. When I pointed about the contradictions, the interviewer got confused himself. Then I told him about possible ways to go forward to clarify the requirements. Which he agreed at that time. So that I can continue on the assignment. After two days when I submitted the assignment in a professional way with so much love and I was proud of my solution. The interviewer rejected my application without giving any feedback on the assignment. Now after passing a few days I have a feeling that the interviewer had job insecurity and he didn't wanted to hire someone better then him. I don't blame him. I think the word of caution here is to never submit 100% working assignment to such companies. In fact its better to inject 1 or two intentional bugs in it. So that the interviewer doesn't feel insecure of you.