The Morning Paper

JUNE 16, 2019

For good query performance we’d like to pre-compute these per-user universes. If we do that naively though, we’re going to end up with a lot of universes to store and maintain and the storage requirements alone will be prohibitive. It therefore requires partially-materialized views that support high-performance updates.

Database 90

Database Cache Benchmarking Efficiency 90

Scalegrid

JUNE 4, 2020

In this post, we are going to compare the performance and pricing of DigitalOcean PostgreSQL vs. ScaleGrid PostgreSQL to help you determine the best PostgreSQL hosting service on DigitalOcean. On average, ScaleGrid provides over 30% more storage vs. DigitalOcean for PostgreSQL at the same affordable price. Compare Pricing. Single Node.

Database 230

Database Latency Benchmarking Performance 230

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. Derived Workloads.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

APRIL 7, 2023

To illustrate this, I ran the Sysbench-TPCC synthetic benchmark against two different GCP instances running a freshly installed Percona Server for MySQL version 8.0.31 on CentOS 7, both of them spec’d with four vCPUs but with the second one (server B) having a tad over twice as much memory than the reference one (server A).

Tuning 137

Tuning Cache Servers Benchmarking 137

Particular Software

SEPTEMBER 20, 2021

It’s less of an apples-to-oranges comparison and more like apples-to-orange-sherbet. Why RPC is “faster” It’s tempting to simply write a micro-benchmark test where we issue 1000 requests to a server over HTTP and then repeat the same test with asynchronous messages. But the answer isn’t that simple.

Benchmarking 97

Benchmarking Latency Servers Systems 97

Alex Russell

APRIL 29, 2021

Classics of the genre include: Apple's just focused on performance! The Performance Argument. As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. This is as it should be.

Media 145

Media Games Education Engineering 145

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance. HammerDB difference from Sysbench.

Best Practices 40

Best Practices Scalability Performance C++ 40

SQL Performance

AUGUST 27, 2019

The initial reviews and benchmarks for these processors have been very impressive: AMD EPYC 7002 Series Rome Delivers a Knockout. AMD Rome Second Generation EPYC Review: 2x 64-core Benchmarked. TPC-H Benchmark Results with SQL Server 2017. TPC-E Benchmark Results with SQL Server 2017. In this case, 6,716.88/64

Servers 52

Servers Benchmarking Virtualization Architecture 52

ScaleOut Software

MAY 15, 2014

For example, the IMDG must be able to efficiently create millions of objects in each server to make use of its huge storage capacity. In addition to looking at performance differences, we also want to compare ScaleOut StateServer (SOSS) to AppFabric on qualitative measures, such as features, ease of installation, and management.

Cache 40

Cache Servers Network Design 40

SQL Server According to Bob

JANUARY 11, 2020

​​ This is similar to the ​​ suspend and resume ​​ operations performed by ​​ the operating system. Streams ​​ NTFS volumes ​​ enable ​​ data files to have one or more secondary storage streams.

Servers 40

Servers Cache Database Media 40

Scalegrid

JULY 13, 2020

Comparison Overview. There are a wide range of tools and extensions for every conceivable scenario, like performance profiling, auditing, etc. pg_repack – reorganizes tables online to reclaim storage. Let’s take a look at core functionality of these two relational database management systems. PostgreSQL. Scalability.

Open Source 244

Open Source Tuning C++ Database 244

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

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