Rigor

JANUARY 13, 2020

Reading time 1 min Why share the library of the web performance books while there’s a substantial collection of fantastic websites and articles on the net? High Performance Browser Networking. This book is about performance problems and the various technologies created to fight them. High Performance Websites.

Performance 75

Performance Social Media Website Website Performance 75

SQL Performance

JULY 1, 2021

These types are on the deprecated list for many reasons, and have held a permanent spot on that list since being replaced by the max types way back in SQL Server 2005. t2 ( id bigint IDENTITY PRIMARY KEY , msg ntext ) ; Now, let's try to perform online operations on the tables: ALTER TABLE dbo. name , [ Column ] = c.

C++ 58

C++ Database Servers Performance 58

SQL Performance

AUGUST 1, 2022

75 Test XYZ Student C 55 Test XYZ 77.5 75 Test XYZ Student C 55 Test XYZ 77.5 If you’re using T-SQL to compute percentiles as part of your work, these functions should be familiar to you since they’ve been supported in SQL Server 2005 and later. 75 Test XYZ Student D 55 Test XYZ 77.5 75 Test XYZ Student H 65 Test XYZ 77.5

Servers 142

Servers Testing C++ Code 142

SQL Performance

OCTOBER 9, 2019

As an example, suppose that you need to perform some task per database in your instance. Using a cursor, you would normally use code similar to the following: DECLARE @dbname AS sysname ; DECLARE C CURSOR FORWARD_ONLY STATIC READ_ONLY FOR. databases ; OPEN C ; FETCH NEXT FROM C INTO @dbname ; WHILE @@FETCH_STATUS = 0.

C++ 111

C++ Database Servers Code 111

All Things Distributed

SEPTEMBER 20, 2013

The first practical modern implementation is probably C-Store by Stonebraker, et al. Many of the modern high-performance data warehouses such as Amazon Redshift are based on column stores. There is a great tutorial by Harizopoulos, Abadi and Boncz from VLDB 2009 that takes you through the history, trade-off''s and the state of the art.

Storage 90

Storage Hardware Cache C++ 90

Smashing Magazine

DECEMBER 2, 2021

Good ol’ PerfPlanet is back for another season with all things speed and web performance. Anyone is welcome to contribute to the calendar , so do feel free to reach out with a topic or tool you’re passionate about, or a technique you’d like to teach and tell the web performance community about. C# Advent Calendar. Rock on! ??.

Design 107

Design Development Programming Website 107

Daniel Lemire

FEBRUARY 8, 2019

I believe that all optimizing C/C++ compilers know how to pull this trick and it is generally beneficial irrespective of the processor’s architecture. In concrete terms, here is the C code to compute the remainder of the division by some fixed divisor d : uint32_t d =. ; // your divisor > 0. Can we do better?

C++ 279

C++ Benchmarking Hardware Testing 279