SQL Performance

FEBRUARY 17, 2022

In SQL Server 2017, however, STRING_AGG() finally answered long-standing and widespread pleas from the community to simulate GROUP_CONCAT() and similar functionality found in other platforms. On more than one occasion, I had to double-check the code was even mine. But is it the most efficient? A Quick Example. FavoriteBands. (

Servers 82

Servers Code Efficiency Performance 82

The Netflix TechBlog

DECEMBER 23, 2020

This abstraction allows the compute team to influence the reliability, efficiency, and operability of the fleet via the scheduler. We do this for reliability, scalability, and efficiency reasons. Let’s go back to that kernel code example earlier. Road to Implementation We began work to enable user namespaces in early 2017.

Media 286

Media Metrics Systems Processing 286

Dynatrace

DECEMBER 16, 2019

Even small amounts of technical debt compound as new code branches from old, further embedding the shortcomings into the system. Technical Debt—Dilbert Comic Strip on 2017-01-03. In the next blog, we’ll look at a few examples of how intellectual debt might begin to accrue unnoticed, with an eye towards its impact on IT efficiency.

Artificial Intelligence 153

Artificial Intelligence Traffic Efficiency Innovation 153

SQL Performance

OCTOBER 14, 2020

Then, you will probably want to continue reading this section and test the code that I use as I revisit key unnesting examples that I previously demonstrated with derived tables and convert them to use CTEs. Since we have only five shippers, there are only five index seek operations, resulting in a very efficient plan. ( SELECT S.

C++ 52

C++ Servers Code Efficiency 52

Percona

DECEMBER 21, 2023

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. While sorting may seem simple, it’s important to understand how to do it efficiently and effectively to ensure your queries are optimized and use better indexing.

Efficiency 103

Efficiency Database Open Source Performance 103

Tasktop

JANUARY 18, 2022

Offload your brain to code at the speed of thought” . I had been begging Mik to write a book for more than a decade, and he finally did over the course of 2017 and 2018. And what a book Mik authored. Without our ecosystem, we would not be where we are today.

Open Source 98

Open Source Speed Games Software 98

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. Via various optimization techniques, such as advanced query optimization, efficient indexing, and fast data processing, MariaDB can deliver excellent performance even when running heavy workloads.

Open Source 52

Open Source Servers Storage Scalability 52

Testsigma

APRIL 27, 2020

As we move forward, organizations need to get out of their silos and follow a more collaborative and efficient process to achieve excellence. Successfully implementing DevOps practices in your organization can have a significant impact through improved efficiency, greater security, and organizational collaboration. Innovative Mindset.

DevOps 53

DevOps Innovation Efficiency Testing 53

ACM Sigarch

APRIL 26, 2018

They unveiled their first two embedded AI chips fabricated with TSMC 40nm process in December 2017: “Journey 1.0 Image Processing Unit (IPU) is the Pixel Visual Core designed by Google and integrated in Google Pixel 2 released in 2017. In 2017, Intel Movidius announces its latest generation VPU, named Myriad X.

Hardware 99

Hardware Artificial Intelligence Architecture Google 99

Randon ASCII

FEBRUARY 16, 2021

I don’t have access to this source code but I looked through the stacks for a bit and they seemed to suggest that explorer.exe was spending more than 20 seconds doing a lot of tasks related to… arranging icon positions. Despite the obvious awareness of this issue we, as an industry, keep shipping code that is quadratic.

Monitoring 141

Monitoring Testing Code Servers 141

Testsigma

JANUARY 13, 2021

Studies show that in 2017, the worldwide failure rate of iOS apps was as high as 54%, with Android apps crashing 10% of the time. By using simple, efficient and automated mobile application testing tools like Testsigma , companies can avoid embarrassing themselves and prevent app glitches significantly.

Mobile 54

Mobile Strategy Testing Efficiency 54

Percona

AUGUST 17, 2023

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. That community spans expertise and industries, putting diverse skill sets and fresh perspectives into the review and improvement of code. And there’s a global community dedicated to keeping it open source.

Open Source 78

Open Source Healthcare Social Media Database 78

Sutter's Mill

FEBRUARY 13, 2017

Today, this makes concurrency more important than ever, because it delivers two things: It hides latencies we have to deal with and cannot remove, from disk I/O latency to speed-of-light network latency; and it makes our code responsive by not introducing needless latencies of our own even when we’re not hiding someone else’s latency.

Latency 51

Latency C++ Hardware Performance 51

SQL Performance

SEPTEMBER 5, 2019

You can skip the WHERE clauses if you are running SQL Server 2017. OPTION ( MAXDOP 1 ) ; This time, only the COUNT_BIG aggregate achieves aggregate pushdown (SQL Server 2017 only). This is an optimization added at some point in SQL Server 2017 (my tests were run on CU16). OPTION ( MAXDOP 1 ) ; SELECT.

Performance 81

Performance C++ Storage Servers 81

The Netflix TechBlog

MAY 1, 2019

In late 2017, we received some critical feedback from the brothers on the Stranger Things 2 audio mix: in some scenes, there was a reduced sense of where sounds are located in the 5.1-channel We expect these bitrates to evolve over time as we get more efficient with our encoding techniques.

Engineering 274

Engineering Network Media Entertainment 274

Enprowess

NOVEMBER 2, 2021

Code Maintainability. Bloomberg – Efficient, simple-to-access, personalized content for end-users with automatic code refreshing options. Its first release was in May 2017 and was rarely used by developers, but it continues its speedy growth and becomes more and more popular in the developer community. Ease of Testing.

Development 52

Development Social Media Mobile Code 52

SQL Performance

MARCH 17, 2020

It comes set to SQL Server 2008 compatibility (level 100), but we will start with a more modern setting of SQL Server 2017 (level 140): ALTER DATABASE StackOverflow2013 SET COMPATIBILITY_LEVEL = 140 ; The tests were performed on my laptop using SQL Server 2019 CU 2. The code may be easier to read and understand than the recursive CTE.

Servers 86

Servers Tuning Database Efficiency 86

Percona

MARCH 30, 2023

In simple terms, an open source database is this: It’s a database with source code that is free and available to all. Public accessibility enables and allows users to download, modify, and distribute the code. Their work produces higher-quality code and enables faster innovation, while maintaining high security standards.

Open Source 75

Open Source Database Storage Scalability 75

Smashing Magazine

FEBRUARY 3, 2022

These numbers are based on first-page load — caching seems very efficient for subsequent page loads. We can see that some types of embeds are more efficient than others: Instagram embeds load asynchronously by default, so they don’t block the main thread. This post from 2017 outlines some stats and some possible reasons.)

Social Media 102

Social Media Media Website Airlines 102

Alex Russell

JANUARY 30, 2024

Most sites, even those that aspire to be "lived in", feature short median sessions, which means we can't actually justify much in the way of up-front code, and first impressions always matter. So what did $650, give or take, buy in late 2017 or early 2018? but which blessedly sports 8GB of RAM.

Performance 90

Performance Network Mobile Speed 90

Alex Russell

FEBRUARY 3, 2023

SSR is vital because SPAs take a long time to start up, and you aren't using our vapourware to split your code effectively. As Stigliz memorably quipped : Adam Smith's invisible hand — the idea that free markets lead to efficiency as if guided by unseen forces — is invisible, at least in part, because it is not there.

Social Media 119

Social Media Website Technology Technology 119

O'Reilly

MARCH 23, 2023

It can explain code that you don’t understand, including code that has been intentionally obfuscated. Sydney The internal code name of the chatbot behind Microsoft’s improved search engine, Bing. Bard Google’s code name for its chat-oriented search engine, based on their LaMDA model, and only demoed once in public.

Google 103

Google Open Source Programming Code 103

CSS - Tricks

APRIL 1, 2021

A 2017 study by Akamai says as much when it found that even a 100ms delay in page load can decrease conversions by 7% and lose 1% of their sales for every 100ms it takes for their site to load which, at the time of the study, was equivalent to $1.6 The code for the site is available on GitHub for reference.

Cache 92

Cache Social Media Media Network 92

CSS - Tricks

MARCH 13, 2019

The first time I made an image responsive, it was as simple as coding these four lines: img { max-width: 100%; height auto; /* default */ }. That way, the number of obscure edge cases can be reduced and the images can be handled as efficiently as possible. See the code example below. <main>

Media 72

Media Artificial Intelligence Strategy Open Source 72

Enprowess

JANUARY 12, 2022

Easy Deployment: PWAs can be deployed easily using a single code base that runs on accelerated mobile pages and web browsers. Twitter Lite PWA : It was integrated as the standard User Interface in 2017. So, by cutting down the repetitive and time-consuming tasks, businesses can improve companies’ efficiency and productivity.

Blockchain 59

Blockchain IoT Development Serverless 59

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. WebGL 2 launched for other platforms on Chrome and Firefox in 2017. These TransformStream types help applications efficiently deal with large amounts of binary data. CSS Custom Paint.

Media 145

Media Games Education Engineering 145

Alex Russell

OCTOBER 22, 2017

— Alex Russell (@slightlylate) October 4, 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. Maybe "ambush by JS"? First Load.

Performance 68

Performance Benchmarking Network Mobile 68

Smashing Magazine

DECEMBER 22, 2021

Accessibility goes far beyond the code, so when it comes to delivering accessible websites, each person in a team has their specific responsibilities. To help us do better, UX Planet published a four-part article series on streamlining the checkout experience back in 2017 which is still gold for everyone working on a checkout flow today.

Airlines 129

Airlines Mobile Design Strategy 129

Randon ASCII

APRIL 17, 2018

When you own all of the code then this may involve some back of the envelope estimates, competitive benchmarking, or intuition tuned by experience. VsChromium is a Visual Studio extension that keeps all of the source code in a monitored directory loaded into RAM. We know that this code is running too slow.

Monitoring 43

Monitoring C++ Code Processing 43

Brendan Gregg

NOVEMBER 13, 2017

My colleague Justin Becker is also giving a talk at QConSF 2017 on the topic: [Am I a Brilliant Jerk?]. Alice is great at fixing hard bugs, writing test suites, doing code merges, and other unglamorous work. Other staff devise processes to work around Bob, reducing the company's efficiency. The A **e Survival Guide.

Engineering 111

Engineering Energy Technology Technology 111

Smashing Magazine

JANUARY 7, 2019

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? The first render tends to warm up a bunch of lazily compiled code, which a larger tree can benefit from when it scales.

Performance 104

Performance Cache Network Metrics 104

John McCalpin

JANUARY 22, 2018

Introduction: In December 2017, my colleague Damon McDougall (now at AMD) asked for help in porting the fused multiply-add example code from a Colfax report ( [link] ) to the Xeon Phi x200 (Knights Landing) processors here at TACC. A peculiar throughput limitation on Intel’s Xeon Phi x200 (Knights Landing).

Latency 40

Latency Hardware Code Testing 40

SQL Performance

APRIL 23, 2019

All column segments within a row group must be implicitly sorted the same way so SQL Server can efficiently reconstruct complete rows from the column segments. Still, when the plan generally qualifies for grouped aggregate pushdown, both pushdown (fast) and non-pushdown (slow) code paths are made available. 2 , -- print option.

Servers 67

Servers Testing Metrics Storage 67

SQL Performance

SEPTEMBER 2, 2021

I’ve written several articles about this function (and STRING_AGG, which arrived in SQL Server 2017) since this post was written: Performance Surprises and Assumptions : STRING_SPLIT(). SQL Server Split String Replacement Code with STRING_SPLIT. He spent a lot of time fine-tuning this CLR function to efficiently parse a string.

C++ 59

C++ Servers Testing Database 59

Smashing Magazine

JULY 29, 2019

Minification removes unnecessary spaces and characters, but uglification actually ‘mangles’ the code to be shorter. The tell-tale sign is that the code contains short, machine-generated variable names rather than untouched source code. But I suspect a lot of it is tracking code and advertising setup. Large preview ).

Cache 96

Cache Google Mobile Network 96

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