Pergunta de entrevista da empresa Healios
You have a report generation UI (backed by Rails/Postgres) that has poor performance, causing your application to hang. How would you improve this?
Resposta da entrevista
Sigiloso
17 de jan. de 2023
- Index database to improve performance - Add read replicas to ensure you're not impacting other users - Pre-calculate expensive derived data models - Asynchronously send the report to the user by some other means (notification/email/etc.) - Explore using an OLAP datastore for these sorts of queries instead of OLTP