My beloved website is slow

But it works fine on my machine!

Performance and maintainability

Cache

Pros

Cons

• builtin frameworks
• fast lookup

• cache invalidation
• slow first request
• needs a good candidate

https://guides.rubyonrails.org/caching_with_rails.html

Database view

• better abstraction

Pros

Cons

• do not improve performance
• complex migrations

https://www.postgresql.org/docs/14/sql-createview.html

Materialized view

https://www.postgresql.org/docs/14/sql-creatematerializedview.html

Pros

Cons

• better abstraction
• fast lookup

• complex migrations
• cache invalidation

https://github.com/scenic-views/scenic

Read model

Pros

Cons

• fast lookup
• better abstraction
• builtin invalidation

• requires deep changes in architecture
• against habits (denormalization)
• cannot change data directly where they are read

monterail.com/blog/introduction-to-domain-events

Questions?

@yanoo_