An Intellyx Brain Candy Brief The founders of PingCAP realized that existing open-source databases like mySQL were decades old and thus leveraged out-of-date architectures. Then they asked themselves: if they were to build the ideal open-source database, what would it be? The result is TiDB. TiDB is a mySQL-compatible distributed database that offers both a […]| Intellyx – The Digital Transformation Experts – Analysts
I had discussed about query optimization techniques applicable to queries involving partitioned tables in PGConf.India 2018 (Video recording, slides). (My previous blog discusses these techniques in detail.) The takeaway from that presentation was these query optimization techniques improved query performance if the tables were already partitioned. But partitioning wasn't good enough as a query optimization strategy by itself even when partitionwise join, partitionwise aggregate and parallel ...| Walking with the Elephants
Discover the best free DBaaS: your essential guide to choosing a provider and comparing TiDB Serverless vs. PlanetScale.| TiDB