Posts

All the articles I've posted.

• Optimizing MySQL Indexing for Maximum Performance

  Published:Jul 25, 2023 |  at 04:00 PM

  Indexing in MySQL is a performance optimization technique that involves creating data structures on specific columns to accelerate query retrieval, but misuse, such as over-indexing or choosing inappropriate columns, can lead to database inefficiencies and performance issues.

• How I scaled a trading engine to 100K TPS?

  Updated:Jul 23, 2020 |  at 03:22 PM

  How Migrating to Go-Lang Transformed a Cryptocurrency Exchange's Matching Engine, Achieving High Concurrency, Low Latency, and Optimal CPU Utilization for Enhanced Trade Speeds