Case Study: a top 150 global bank achieves faster, more flexible bank statement queries with TiDB from PingCAP

Top 150 Global Bank cuts statement query response time by 44% with PingCAP

The customer, a top 150 global bank, faced challenges with its bank statement query system. As data volumes grew, its second-generation big data architecture struggled with performance bottlenecks, resource contention, and an inability to handle real-time, same-day transaction queries. To enhance flexibility and efficiency, the bank partnered with vendor PingCAP to implement their TiDB distributed SQL database.

PingCAP's TiDB provided a next-generation solution with an active-active deployment for high availability and financial-grade data consistency. This resulted in a 44% performance boost, reducing query response times from 90ms to under 50ms. The solution also extended query date ranges up to five years, ensured 99.99% availability, and reduced application development costs by simplifying the technology stack with standardized SQL.