SQL Performance

OCTOBER 13, 2021

I also compare them with stored procedures, mainly focusing on differences in terms of default optimization strategy, and plan caching and reuse behavior. Before implementing the function itself, here’s code to create a supporting index on the Sales.Orders table: USE TSQLV5 ; GO. CREATE INDEX idx_nc_cid_odD_oidD_i_eid ON Sales.

Cache 144

Cache Strategy C++ Code 144

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]. 2019-01-07T12:00:13+00:00. 2019-04-29T18:34:58+00:00. Ad Weight Impact If your site depends on the revenue generated by advertising, it’s useful to track the weight of ad related code.

Performance 104

Performance Cache Network Metrics 104

HammerDB

JUNE 27, 2022

Given the increasing importance of open source and the widespread use of HammerDB, the TPC adopted HammerDB in 2019 and now hosts the project on GitHub. HammerDB supports 2 workloads derived from TPC specifications to test these different requirements, namely TPROC-C derived from TPC-C for OLTP and TPROC-H derived from TPC-H for OLAP.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Brendan Gregg

AUGUST 29, 2021

100.00 ^C I'm looking at the r_await column in particular: the average wait time for reads in milliseconds. Reads usually have apps waiting on them; writes may not (write-back caching). Hit Ctrl-C to end. ^C Hit Ctrl-C to end. ^C This is a 64-Gbyte memory system, and 48 Gbytes is in the page cache (the file system cache).

Cache 40

Cache C++ AWS Systems 40

SQL Server According to Bob

MAY 19, 2019

As you can imagine, with a code base as large and vast as SQL Server, there is always room for improvement. There are a bunch of folks with compiler, linker, SQL Server code, testing and other disciplines who provided input. The lock manager has partitions, lock block cache and other structures. IO Request Caches.

IoT 61

IoT Servers Development Cache 61

Smashing Magazine

JUNE 30, 2021

iOS empowers developers to easily parallelize code using Grand Central Dispatch , Android does this via their new, unified task scheduler WorkManager and game engines like Unity have job systems. How long your piece of JavaScript takes to finish depends on how fast the device is that your code is running on.

Games 145

Games Architecture Code C++ 145

Smashing Magazine

JANUARY 11, 2021

Have we optimized enough with tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, progressive hydration, clients hints, HTTP/3, service workers and — oh my — edge workers? It’s much easier to reach performance goals when the code base is fresh or is just being refactored.

Performance 145

Performance Cache Media Metrics 145