SQL Performance

DECEMBER 27, 2019

Of course we can always throw more disk at a table, but I wanted to see if we could scale this more efficiently than the current linear trend. Note that I am not focusing on reporting workload or other read query performance at this time – I merely want to see what impact I can have on storage (and memory) footprint of this data.

Database 70

Database Storage Hardware Efficiency 70

The Morning Paper

APRIL 16, 2019

Teaching rigorous distributed systems with efficient model checking Michael et al., During the ten week course, students implement four different assignments: an exactly-once RPC protocol; a primary-backup system; Paxos; and a scalable, transactional key-value storage system. Consider the lab exercise to implement Paxos.

Systems 43

Systems Efficiency Testing Design 43

SQL Performance

NOVEMBER 30, 2021

Whether the page is dirty or not (a dirty page has changes on it that haven’t yet been written back to durable storage). Let’s pretend there *is* a highly efficient mechanism to determine buffer pool contents the optimizer can use to help it choose which index to use in a query plan.

Efficiency 54

Efficiency Servers Database Cache 54

Tasktop

OCTOBER 29, 2020

The family returns to a completely transformed dream house, sparkling with new appliances, luxurious new furniture and plenty of functional storage. . It’s the gym membership that forces you to exercise. There, while the family is whisked away to a Disney vacation, cramped and messy homes are miraculously remodeled within a week.

Storage 52

Storage Speed C++ DevOps 52

Alex Russell

AUGUST 30, 2021

Large projects like browser engines also exercise governance through a hierarchy of "OWNER bits," which explicitly name engineers empowered to permit changes in a section of the codebase. But is HR cost efficiency for Apple the most important feature of a web engine?

Engineering 112

Engineering Open Source Website Operating System 112

Alex Russell

SEPTEMBER 20, 2020

When working well — efficiently applying unobjectionable policy — store screening is invisible to everyone but developers. Not draining other's bank accounts may be something of an exercise to the reader. ??. webviews can plumb arbitrary native capabilities into web content they host, providing isolated-storage with expanded powers.

Hardware 71

Hardware Mobile Programming Java 71

Tasktop

JUNE 25, 2020

I recall a question I posed to Nicole Bryan (now Tasktop’s Chief Product Officer) in those early days: If Tasktop provides the information highway for data to flow faster between collaborators, why don’t we also provide metrics and analytics on the speed and efficiency of their work? Her answer: It’s coming. . And it has.

Metrics 52

Metrics Education Innovation Software 52

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ). Figure 5: Plan for Query 5.

C++ 109

C++ Database Servers Code 109

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ). Figure 5: Plan for Query 5.

C++ 93

C++ Database Servers Code 93