5.8 Query-Update Techniques
Queries run for a long time and lock a lot of data — a performance nightmare when trying also to run short update transactions
There are several good solutions
- Use a data warehouse
- Accept weaker consistency guarantees
- Use multiversion data
Solutions trade data quality or timeliness for performance