Glossary term
What is OLTP (Online Transaction Processing)?
OLTP stands for Online Transaction Processing.
Many small, fast reads/writes. Example: Placing orders, updating profiles.
Learn it properly · System DesignLesson 5: SQL Basics Every System Designer NeedsBefore sharding, replicas or NoSQL, learn to use one relational database well. Tables and keys, the queries you will write every day, indexes and EXPLAIN, the N+1 trap, transactions, and the connection limit that takes databases down.