Pregunta de entrevista de 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?
Respuesta de la entrevista
Anónimo
17 ene 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