SQL Performance

NOVEMBER 13, 2019

Here's the definition of the POC that supports our query: CREATE INDEX idx_grp_data_i_id ON dbo. But we're on a quest to find an efficient solution where the optimizer can realize that there's no ordering relevance. Consider the following UDF definition as an example: DROP FUNCTION IF EXISTS dbo. Constant folding. RETURN NULL.

Servers 104

Servers C++ Storage Performance 104

Smashing Magazine

JANUARY 7, 2019

From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19). From Fast By Default: Modern Loading Best Practices by Addy Osmani (Slides 18, 19). In exchange, your team gains maintainability and developer efficiency, of course. Image source: Katie Hempenius ) ( Large preview ).

Performance 103

Performance Cache Metrics Network 103

Smashing Magazine

JANUARY 6, 2020

From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19). In exchange, your team gains maintainability and developer efficiency, of course. A sample output by imaging-heap , a command line tool that measure the efficiency across viewport sizes and device pixel ratios. Image source ) ( Large preview ).

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 11, 2021

From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19). On top of that, with Elena Kirilenko’s research , we can achieve fast and efficient Brotli recompression using previous compression artifacts. Performance budgets should adapt depending on the network conditions for an average mobile device.

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

NOVEMBER 30, 2021

Adding A Dyslexia-Friendly Mode To A Website written by John C Barstow. We last talked to him in July 2020 , where we asked if modern best practices about for the web. And so we can definitely dig into that in a bunch of different angles, depending on where you want to take this conversation. How To Maintain A Large Next.js

Technology 94

Technology Technology Servers Code 94

Smashing Magazine

AUGUST 9, 2021

QUIC is needed because TCP, which has been around since the early days of the Internet, was not really built with maximum efficiency in mind. It combines decades of deployment experience and best practices of TCP with some core new features. For example, if we have files A, B, and C, we would have three TCP connections.

Transportation 145

Transportation Internet Internet Network 145

Smashing Magazine

AUGUST 22, 2021

While a perfect understanding of these concepts is not needed for the rest of this post, having a common high-level definition would be good. One aspect of performance is about how efficiently a transport protocol can use a network’s full (physical) bandwidth (i.e. As such, one best practice or optimization can end up undoing another.

Performance 105

Performance Network Latency Servers 105

Smashing Magazine

SEPTEMBER 6, 2021

You would, however, be hard-pressed even today to find a good article that details the nuanced best practices. This is because, as I stated in the introduction to part 1 , much of the early HTTP/2 content was overly optimistic about how well it would work in practice, and some of it, quite frankly, had major mistakes and bad advice.

Network 104

Network Servers Cache Traffic 104