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

Database view

  • better abstraction

Pros

Cons

  • do not improve performance
  • complex migrations

Materialized view

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

Questions?

@yanoo_

My beloved website is slow

By Jan Dudulski

My beloved website is slow

  • 98