Question d’entretien chez 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?
Réponse à la question d'entretien
Utilisateur anonyme
17 janv. 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