# Solution 2: TiDB
+ 3x-5x P99 query latency reduction
+ Standard SQL interface
+ Native cross-table strong consistency transactions are guaranteed
+ Operation task has been significantly simplified
  + The SQL layer and storage layer can be horizontally scaled independently

![`smart`](./student-guide/diagram/CaseStudySocialCompanyGen2_aa_003_20230326.png)
----------------------------------------------------------------------------------
Benefits:
- Cost and on-call reduced.
- Structured data store, standard SQL, strong consistency transactions.
- Zero downtime upgrade of each components: PD, TiDB and TiKV.


























