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.