SQL Performance

APRIL 20, 2021

We are now ready to start the query scan, perform some early phase processing, and start the first additional parallel tasks. The query processor begins execution by starting the query scan process via a call to CQueryScan::StartupQuery. Every process needs a containing transaction, and additional parallel tasks are no exception.

C++ 98

C++ Processing Servers Cache 98

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

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). Recommended reading : WordPress Security As A Process. Before we delve deeper in the code, a couple more things about WordPress REST API.

Cache 78

Cache Website Speed Database 78

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

Alex Russell

OCTOBER 22, 2017

Answering it requires an understanding of how browsers process resources (which differs by type) and the concept of the critical path. This input processing happens on document’s main thread , where JavaScript runs. Processing input (including scrolling w/ active touch listeners). ” A good question!

Performance 68

Performance Benchmarking Network Mobile 68

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 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

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

For the more adventurous/technical, the top (table of processes) command provides similar metrics on most Unix-like operating systems such as macOS and Ubuntu. In 2016, O’Reilly published “ Designing For Sustainability ” by Tim Frick. Generally speaking, we can also run the top command on any server to which we have shell access.

Website Performance 73

Website Performance Website Energy Performance 73

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. Helps media apps on the web save battery when doing video processing.

Media 145

Media Games Education Engineering 145

Percona

JUNE 4, 2023

Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. Efficient data processing and indexing, making it optimal for executing queries and handling large datasets.

Open Source 52

Open Source Servers Storage Scalability 52

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. The process to enable this for a database is described in our documentation. At first glance in SQL Server 2016, you can see if a database is encrypted for TDE by looking at sys.databases.is_encrypted.

Servers 40

Servers Database Azure Cache 40

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!

C++ 48

C++ Programming Code Virtualization 48

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

Smashing Magazine

JULY 6, 2021

Moving to a headless CMS is not an easy decision and the selection process should not be taken lightly. 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. Microservices architecture.

Cache 143

Cache Website Mobile Google 143