Smashing Magazine

JANUARY 11, 2021

Front-End Performance Checklist 2021. Front-End Performance Checklist 2021. This guide has been kindly supported by our friends at LogRocket , a service that combines frontend performance monitoring , session replay, and product analytics to help you build better customer experiences. Web performance is a tricky beast, isn’t it?

Performance 145

Performance Cache Media Metrics 145

SQL Performance

DECEMBER 8, 2021

It's a pretty common need in real life; it's simple to describe, and it's quite easy to solve with reasonable performance using a cursor-based solution. When Peter sends me a puzzle, I typically respond with a suggested solution, and he usually comes up with a better-performing, brilliant solution. L0 AS ( SELECT 1 AS c.

C++ 133

C++ Code Benchmarking Performance 133

SQL Performance

AUGUST 12, 2020

Of course, I’ll demonstrate this design aspect in this article. What’s different about the design of CTEs compared to derived tables is where in the code these three elements are located. However, there are very few cases in T-SQL where without a terminator the code is ambiguous. The elements are sort of intertwined.

C++ 140

C++ Code Design Database 140

The Morning Paper

MAY 27, 2019

CheriABI: enforcing valid pointer provenance and minimizing pointer privilege in the POSIX C run-time environment Davis et al., That ‘reasonable’ performance cost is a 6.8% code is not given access to excessive capabilities. And this all has to work for whole-system executions, not just the C-language portion of user processes.

C++ 61

C++ Hardware Virtualization Benchmarking 61

Alex Podelko

OCTOBER 28, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. Sometimes it even lead to conclusions like “performance testing hitting the wall” just because load generation may be a challenge. – Cloud.

Performance Testing 100

Performance Testing Technology Technology Testing 100

SQL Performance

APRIL 13, 2022

Finally, I’ll compare the performance of the different solutions. Use the following code to create a table called T1 and populate it with a small set of sample data: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. To test the performance of your solution, you’ll need to populate the table with larger volumes of sample data.

C++ 136

C++ Strategy Testing Servers 136

SQL Performance

JULY 13, 2022

This could also happen if you need to migrate code written for another database platform with a different dialect of SQL to T-SQL. Use the following code to create the Orders table and populate it with a small set of sample data to help you verify the validity of the solutions: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo.

C++ 112

C++ Code Azure Database 112

SQL Performance

MAY 24, 2022

This clause allows you to shorten your code by avoiding the repetition of identical parts of your window specifications. As an example where the WINDOW clause can be handy in shortening your code, consider the following query: USE TSQLV6 ; SELECT orderid , custid , orderdate , qty , val , SUM ( qty ) OVER ( PARTITION BY custid.

Servers 145

Servers C++ Code Database 145

SQL Performance

JANUARY 13, 2021

Here’s the code to create the dummy table: CREATE TABLE dbo. BatchMe ( col1 INT NOT NULL , INDEX idx_cs CLUSTERED COLUMNSTORE ) ; And here’s the code defining the dbo.GetNumsItzikBatch function: CREATE OR ALTER FUNCTION dbo. L0 AS ( SELECT 1 AS c. L0 AS ( SELECT 1 AS c. BatchMe ON 1 = 0.

C++ 113

C++ Code Testing Processing 113

Percona

JUNE 20, 2023

In order to understand “segmentation fault,” it is a must to know the basic idea of segmentation and its implementation in C programming. Here, memory is divided into equal sizes of partitions where the code of a program resides. So, I decided to gather information and write a detailed blog about this issue.

Programming 85

Programming C++ Database Virtualization 85

Percona

DECEMBER 23, 2022

The use case is the TPC-C benchmark but executed not on a high-end server but on a lower-spec virtual machine that is I/O limited like for example, with AWS EBS volumes. The storage device has performance characteristics pretty similar to an AWS gp2 EBS volume of about 330 GB in size. . <iotune> TPC-C on MyRocks.

Storage 56

Storage Cache C++ Virtualization 56

SQL Performance

NOVEMBER 11, 2020

I provided recommendations in terms of when it makes sense to use CTEs versus when it makes sense to use temporary objects from a query performance standpoint. WITH C AS ( SELECT SYSDATETIME ( ) AS dt ) SELECT @i += 1 FROM C WHERE dt = dt ; PRINT @i ; GO. -- Batch 3. How many iterations did the code report?

C++ 122

C++ Code Storage Processing 122

SQL Performance

MAY 12, 2021

Early on when I posted the puzzle, several people commented that the best performing solution would likely be a CLR-based one. Use the following code to create the database if it doesn’t exist, and to enable I/O and time statistics: -- DB and stats. And here’s the code with the function’s definition: CREATE OR ALTER FUNCTION dbo.

C++ 111

C++ Servers Database Code 111

SQL Performance

MAY 13, 2020

I just wanted to mention some use cases here to illustrate how important table expressions are in our T-SQL code, and why it's worthwhile to invest in understanding their fundamentals well. However, from relational theory's standpoint, there's a deeper meaning to what C represents. C is what's known as a range variable.

C++ 143

C++ Code Design Servers 143

Dynatrace

MAY 23, 2022

IDC predicted, by 2022, 90% of all applications will feature microservices architectures that improve the ability to design, debug, update, and use third-party code. Monolithic architecture is development where an application is built on a single codebase, and the code is unilateral. Faster performance. Too tightly coupled.

Architecture 192

Architecture DevOps Monitoring Programming 192

HammerDB

JUNE 22, 2023

Turning Jobs Off and On Of course one of the most important aspects is to be able to disable the functionality. Copy Code Copied Use a different Browser hammerdb>jobs disable 1 Disabling jobs repository, restart HammerDB to take effect and in the GUI use the Jobs Disabled/Enabled option. In HammerDB v4.7 DATA/hammer.db TMP/hammer.DB

Benchmarking 57

Benchmarking C++ Virtualization Database 57

SQL Performance

JUNE 10, 2020

That is, does SQL Server perform a substitution process whereby it converts the original nested code into one query that goes directly against the base tables? The answer is simple, to shorten the code by having the inner query use the infamous SELECT *. That’s safe and will get handled optimally in terms of index matching.

C++ 109

C++ Database Servers Code 109

Smashing Magazine

JANUARY 6, 2020

Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]. Web performance is a tricky beast, isn’t it? How do we actually know where we stand in terms of performance, and what our performance bottlenecks exactly are? Vitaly Friedman.

Performance 145

Performance Cache Network Metrics 145

SQL Performance

OCTOBER 13, 2021

Before implementing the function itself, here’s code to create a supporting index on the Sales.Orders table: USE TSQLV5 ; GO. Orders ( custid , orderdate DESC , orderid DESC ) INCLUDE ( empid ) ; And here’s the code to create the function, named Sales.GetTopCustOrders: CREATE OR ALTER FUNCTION Sales.

Cache 144

Cache Strategy C++ Code 144

Tech News Gather

DECEMBER 27, 2022

A teacher can use this process to analyze a student’s performance and provide appropriate solutions. Course Management. If you are looking for a top-notch education app development team, make sure it has a course management feature. It is an open-source framework that makes use of a single Dart-written code base.

Education 52

Education Social Media Development Media 52

Smashing Magazine

JUNE 2, 2021

Improving The Performance Of An Online Store (Case Study). Improving The Performance Of An Online Store (Case Study). Every front-end developer is chasing the same holy grail of performance: green scores in Google Page Speed. For this article, we will focus on the first three and the performance adjustments for these.

Performance 115

Performance Cache Website Mobile 115

Alex Russell

MAY 9, 2022

Despite advances in browser tooling , automated evaluation , lab tools , guidance , and runtimes , however, teams struggle to deliver even decent performance with today's popular frameworks. What is Performance? It may seem a silly question, but what is performance, exactly?

Performance 86

Performance Latency Metrics Engineering 86

SQL Performance

JUNE 10, 2020

That is, does SQL Server perform a substitution process whereby it converts the original nested code into one query that goes directly against the base tables? The answer is simple, to shorten the code by having the inner query use the infamous SELECT *. That’s safe and will get handled optimally in terms of index matching.

C++ 93

C++ Database Servers Code 93

SQL Performance

MAY 11, 2022

By following some basic tips you can sometimes reduce the number of explicit sort operators, which can, of course, have a major impact on the performance of the query. You can download the source code to create and populate this database here. Consider the following query, which I’ll refer to as Query 6: WITH C AS. (

C++ 133

C++ Database Servers Code 133

SQL Performance

JULY 1, 2021

t2 ( id bigint IDENTITY PRIMARY KEY , msg ntext ) ; Now, let's try to perform online operations on the tables: ALTER TABLE dbo. An online operation cannot be performed for index 'PK__t2__3213E83FEEA1E0AD' because the index contains column 'msg' of data type text, ntext, image or FILESTREAM. name , [ Column ] = c.

C++ 58

C++ Database Servers Performance 58

Smashing Magazine

JANUARY 7, 2019

Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. Web performance is a tricky beast, isn’t it? How do we actually know where we stand in terms of performance, and what our performance bottlenecks exactly are? Vitaly Friedman.

Performance 103

Performance Cache Metrics Network 103

CSS Wizardry

NOVEMBER 3, 2020

A couple of years ago, my first few days on a new web performance project were always slow going. Unless a client hires you to specifically improve the performance of one page, you’ll need a broad view of the whole site or application. All through no fault of the client or the project, but through huge flaws in my own approach.

Speed 292

Speed Ecommerce Metrics Analytics 292

SQL Performance

SEPTEMBER 25, 2019

Performance spools are lazy spools added by the optimizer to reduce the estimated cost of the inner side of nested loops joins. An example plan shape showing a lazy table performance spool is below: The questions I set out to answer in this article are why, how, and when the query optimizer introduces each type of performance spool.

Performance 104

Performance Cache Servers Education 104

Smashing Magazine

DECEMBER 2, 2021

Advent of Code. If you prefer a puzzle over an article, take a look at Advent of Code. Good ol’ PerfPlanet is back for another season with all things speed and web performance. C# Advent Calendar. It’s time for the fifth annual C# advent calendar that will feature two pieces of content every day. Rock on! ??.

Design 107

Design Development Programming Website 107

The Netflix TechBlog

APRIL 17, 2019

Scalable Video Technology (SVT) is Intel’s open source framework that provides high-performance software video encoding libraries for developers of visual cloud technologies. Reference software serves as the basis for standard development, a framework, in which the performance of video coding tools is evaluated.

Open Source 166

Open Source Scalability Speed Efficiency 166

Sutter's Mill

APRIL 14, 2011

Scott Meyers, Andrei Alexandrescu and I are continuing to craft and announce the technical program for C++ and Beyond (C&B) 2011 , and two more sessions are now posted. All talks are brand-new material created specifically for C&B 2011. Here are short blurbs; follow the links for longer descriptions.

C++ 40

C++ Programming Strategy Scalability 40

Sutter's Mill

JANUARY 11, 2021

Assertions have been a foundational tool for writing understandable computer code since we could write computer code… far older than C’s assert() macro, they go back to at least John von Neumann and Herman Goldstine (1947) and Alan Turing (1949). 1,2] How well do we understand them… exactly? GUIDELINE: Assert liberally. [3]

C++ 58

C++ Programming Code Testing 58

The Morning Paper

NOVEMBER 12, 2019

Scaling symbolic evaluation for automated verification of systems code with Serval Nelson et al., Here are the resulting code and specification sizes, together with the verification runtimes (impressively short!). SOSP’19. Serval is a framework for developing automated verifiers of systems software. Symbolic evaluation primer.

Code 45

Code Systems Programming Google 45

SQL Performance

OCTOBER 9, 2019

Consequently, handling our task becomes a no-brainer: DECLARE @s AS VARCHAR ( 20 ) = '123.456.789,00' ; SELECT TRANSLATE ( @s , '.,' , ',' ) ; This code generates the desired output: 123,456,789.00. Employees ; The next step is of course mindreading. That's pretty neat! TRIM is more than LTRIM(RTRIM()). BEGIN. .' ; /*.

C++ 111

C++ Database Servers Code 111

Smashing Magazine

JULY 18, 2022

You are now “Head of Performance” at Repairing Magazine, the most serious competitor to Smashing Magazine. Your job for today is to implement this feature with the best possible performances. There was something he wanted to C."; There are many use cases: personalization, internationalization, theming, multi-tenancy, A/B tests….

Cache 114

Cache Website Energy Servers 114

HammerDB

FEBRUARY 25, 2021

On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute. This post explains why HammerDB made the language decisions it made to make it the best performing and most usable database benchmarking software. Basic Benchmarking Concepts. select top 100.

Programming 67

Programming Benchmarking Virtualization C++ 67

SQL Performance

APRIL 14, 2021

It has excellent performance, and there’s quite a lot that you can learn from it. Evaluating earlier solutions, one of the important factors in getting good performance was the ability to employ batch processing. Here are the performance numbers that I got in my test: CPU time = 10032 ms, elapsed time = 10025 ms.

C++ 112

C++ Servers Testing Code 112