Solving the 1+N query problem
Summary
Discusses solutions to the 1+N query problem, a common performance issue in database interactions, often related to ORM usage.
Similar Articles
What ORMs have taught me: just learn SQL (2014)
The author argues that ORMs are more detrimental than beneficial and that developers should focus on learning SQL directly to avoid issues like attribute creep and inefficient queries.
118M Queries per Second on Neki
PlanetScale achieved 118 million queries per second on their Neki platform with linear scalability across 512 shards, demonstrating exceptional performance and throughput in database operations.
Making 768 servers look like 1
PlanetScale explains how to scale a relational database from a single server to 768 servers using database sharding, addressing bottlenecks like write limits and resource contention.
Rethinking Database Programming
The article explores new perspectives and challenges traditional approaches to database programming, suggesting innovations to improve efficiency and design.
ZoAQ: Adaptive Zeroth-Order Querying via Query-Reuse Coupling
ZoAQ presents an adaptive zeroth-order optimization method that reuses past queries to reduce evaluation counts, saving 43–48% of queries in synthetic tasks and achieving high success in black-box attacks.