SQL Performance

MAY 29, 2019

From SQL Server 2016 onward, FastLoadContext is enabled by default ; the trace flag is not required. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016. FastLoadContext can be disabled on SQL Server 2016 using documented trace flag 692. The sqllang!CUpdUtil::FOptimizeInsert

Cache 64

Cache Testing Servers Code 64

SQL Performance

SEPTEMBER 25, 2019

The general idea is to cache and replay results, saving repeated executions of inner-side operators wherever possible. When a spool is able to replay cached results, this is known as a rewind. You may find it helpful to think of a spool rebind as a cache miss, and a rewind as a cache hit. Lazy Table Spool.

Performance 104

Performance Cache Servers Education 104

Smashing Magazine

OCTOBER 26, 2018

Because of its history and for being sort of a fork of an old blogging platform called “b2” (more details here ), it’s largely written in a procedural way (using function-based code). Before we delve deeper in the code, a couple more things about WordPress REST API. on December 6th, 2016. Working With WordPress REST API.

Cache 78

Cache Website Speed Database 78

John McCalpin

APRIL 2, 2020

This was a keynote presentation at the “2nd International Workshop on Performance Modeling: Methods and Applications” (PMMA16), June 23, 2016, Frankfurt, Germany (in conjunction with ISC16 ). Here I assumed a particular analytical function for the amount of memory traffic as a function of cache size to scale the bandwidth time.

Benchmarking 59

Benchmarking Performance Latency Architecture 59

John McCalpin

NOVEMBER 5, 2016

In the latest (October 2016) revision of Intel’s Instruction Extensions Programming Reference , Intel has disclosed a fairly dramatic departure from these “traditional” approaches. With 2 FMA units that have 5-cycle latency, the code must implement at least 2*5=10 independent accumulators in order to avoid stalls.

Cache 40

Cache C++ Latency Hardware 40

Rigor

JULY 2, 2019

As an example, we see that the preferred address to access the online edition of the New York Times is [link] (we received an HTTP response code of 200 when requesting the site). Rigor’s waterfall chart indicates that this address has been permanently moved (given that we received an HTTP response code of 301 ).

Mobile 60

Mobile Traffic Google Latency 60

Randon ASCII

FEBRUARY 25, 2018

In September of 2016 we started noticing random failures when building Chrome – 3 out of 200 builds of Chrome failed when protoc.exe, one of the executables that is part of the build, crashed with an access violation. Now we have a problem statement that we can reason about: why are large chunks of our code segment filled with zeroes?

Programming 79

Programming Hardware Cache Code 79

SQL Server According to Bob

DECEMBER 18, 2018

Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system. Before all was said and done, all of these people and more helped with various activities: · Eugene, Mike, Slava, Scott, Peter, Steve and others doing code reviews on my SQL Server and Host Extension changes. ·

Servers 90

Servers Media Cache Storage 90

Smashing Magazine

JUNE 26, 2019

Clean coding practices. Let the web developer handle all of the necessary speed optimizations like caching and file minification while you take on the following design tips and strategies: 1. Granted, some plugins are coded to be more lightweight than others, but there will always be some sort of difference felt in your loading times.

Website 110

Website Speed Mobile Design 110

SQL Performance

APRIL 20, 2021

A reminder of the plan ( click to enlarge ): This is the first point in the process so far that an in-flight execution plan is available (SQL Server 2016 SP1 onward) in sys.dm_exec_query_statistics_xml. We are still executing code for the parent task, using the only thread running right now. Updates the linked map of plan iterators.

C++ 98

C++ Processing Servers Cache 98

Rigor

SEPTEMBER 3, 2019

Response code or issues with the rendered page [Synthetic]. Prior to any peak event, take the time to review your CDN’s cache design and offload metrics to determine what improvements can be made. Ultimately, the key to surviving a peak event is to have very good CDN cache designs. Third-party broken [Synthetic or RUM].

Website 74

Website Cache Ecommerce Traffic 74

Smashing Magazine

JANUARY 15, 2019

In 2016, O’Reilly published “ Designing For Sustainability ” by Tim Frick. Particularly good examples here are Brad Frost’s side-project, “ Death To B t ”, Heydon Pickering’s articles and talks about writing less damn code , and Adam Silver’s blog post, “ Designing For Actual Performance.”. Write CSS Like Your Grandmother.

Website Performance 73

Website Performance Website Energy Performance 73

Alex Russell

OCTOBER 22, 2017

For this page to be done loading it needs to be responsive to user input — the “interactive” in “Time to Interactive” Browsers process user input by generating DOM events that application code listens to. The true median device from 2016 sold at about ~$200 unlocked. Execute the script.

Performance 68

Performance Benchmarking Network Mobile 68

Alex Russell

APRIL 29, 2021

After 20 years of neck-in-neck competition, often starting from common code lineages, there just isn't that much left to wring out of the system. At the time of the last Confluence run, the gap had stretched to nearly 1000 APIs, doubling since 2016. Healthy competition features various parties trading the lead with regularity.

Media 145

Media Games Education Engineering 145

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. At first glance in SQL Server 2016, you can see if a database is encrypted for TDE by looking at sys.databases.is_encrypted. c:public_symbols is a symbol cache and a folder I created on my laptop. Bob Ward.

Servers 40

Servers Database Azure Cache 40

Percona

JUNE 4, 2023

The worklogs are where the design for future releases happens, and these are opened up when their features are fully developed and source-code-pushed. From a source code standpoint, MySQL makes pushes to Github when a release is made, whereas open source development happens for Percona Server for MySQL and MariaDB Server on Github.

Open Source 52

Open Source Servers Storage Scalability 52

The Symphonia

MAY 22, 2018

I started writing “ Serverless Architectures ” in May 2016. I was a little restricted in my thinking the first time around and I’ve come to see FaaS as something not quite stateless, since caching state in a Lambda instance that might stick around for 5 hours is a perfectly reasonable idea. I thought a few folks might be interested.

Serverless 40

Serverless Architecture Lambda Azure 40

Tim Kadlec

JANUARY 31, 2019

Never-Slow Mode isn’t that far removed from two ideas that we had back in 2016 when Yoav Weiss and I met with the AMP team to discuss some standards-based alternatives to AMP. Regarding the actual code the device has to run, that’s still somewhere around 3-4MB which is…well, it’s a lot of JavaScript.

Tuning 76

Tuning Cache Development Performance 76

Nick Desaulniers

NOVEMBER 20, 2016

Let’s say we wanted to reuse some of the code from our previous project in our next one. While static libraries allowed us to reuse source code, static linkage does not allow us to reuse memory for executable code between different processes. This is the second post in a series on memory segmentation. What a waste! tls/libc.so.6

C++ 48

C++ Programming Code Virtualization 48

Smashing Magazine

JANUARY 21, 2019

A component is simply a set of pieces of HTML, JavaScript and CSS code put all together to create an autonomous entity. I will demonstrate this by re-imagining how this example coded for React would fare in a component-based API. Recommended reading : A GraphQL Primer: Why We Need A New Kind Of API. Building A Site Through Components.

Social Media 64

Social Media Database Media Website 64

Smashing Magazine

JULY 6, 2021

With Luminary’s 21 years of experience in the digital space, my experience of 17 years in the CMS space as well as our focus on Headless since 2016, here are my two cents on what you should look out for. All functionality and integrations would also have a tight dependency which in turn results in a large, cumbersome monolithic code base.

Cache 143

Cache Website Mobile Google 143