Percona

DECEMBER 21, 2023

However, for 16 years since 2007, the MySQL query optimizer has had a “bug” that not only makes LIMIT 1 slower than LIMIT 10 but can also make the former a table scan, which tends to cause problems. You must understand how to use indexes to make sorting cheaper. Looking at this, can you say which is faster: LIMIT 1 or LIMIT 10 ?

Efficiency 105

Efficiency Database Open Source Performance 105

The Netflix TechBlog

JANUARY 10, 2024

The Netflix video processing pipeline went live with the launch of our streaming service in 2007. Notably, Netflix launched the Advertising-supported plan in November 2022. Future blogs will provide deeper dives into each service, sharing insights and lessons learned from this process.

Processing 229

Processing Media Latency Innovation 229

Alex Russell

FEBRUARY 24, 2024

Translation: "Why did you break functionality that has been a foundational part of iOS since 2007?" And they did it in the dead of the night, silently disabling important features as close to the DMA compliance deadline as possible. This is going to hurt me more than it hurts you.

Storage 100

Storage Engineering Games Design 100