Percona

MAY 1, 2023

It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. Connection pooling: Minimizing connection overhead and improving response times for frequently accessed data by implementing mechanisms for connection pooling and caching strategies.

Tuning 52

Tuning Efficiency Database Performance 52

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. SQL> alter system flush buffer_cache; System altered.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

The Morning Paper

AUGUST 29, 2019

use the TPC-H benchmark to assess Redshift, Redshift Spectrum, Athena, Presto, Hive, and Vertica to find out what works best and the trade-offs involved. We focused on OLAP-oriented parallel data warehouse products available for AWS and restricted our attention to commercially available systems. Key findings. Query restrictions.

Architecture 76

Architecture Cloud Storage Serverless 76

Percona

AUGUST 31, 2018

If queries perform full table scans where an index could be used or perform heavy joins or expensive aggregate operations, then the system can still perform poorly even if the database parameters are tuned. The PostgreSQL buffer is called shared_buffer which is the most effective tunable parameter for most operating systems.

Tuning 55

Tuning Database Performance Benchmarking 55

Brendan Gregg

FEBRUARY 9, 2018

This overhead can be reduced by A) pcid, fully available in Linux 4.14, and B) Huge pages. - **Cache access pattern**: the overheads are exacerbated by certain access patterns that switch from caching well to caching a little less well. Also microbenchmarks, which often stress-test the system, will suffer the largest losses.

Performance 75

Performance Benchmarking Cache Tuning 75

Smashing Magazine

JUNE 2, 2021

The project consisted of upgrading the shop software to our own open-source system and redoing the shop’s front end from scratch. Today, the website is much faster and ranks highly in various showcases and benchmarks. And while you can usually cache the full page of an article, the same is not true of many shop pages and elements.

Performance 117

Performance Cache Website Mobile 117

Brendan Gregg

FEBRUARY 8, 2018

This overhead can be reduced by A) pcid, fully available in Linux 4.14, and B) Huge pages. - **Cache access pattern**: the overheads are exacerbated by certain access patterns that switch from caching well to caching a little less well. Also microbenchmarks, which often stress-test the system, will suffer the largest losses.

Performance 40

Performance Benchmarking Cache Tuning 40

Smashing Magazine

JUNE 1, 2022

You can adjust what browser is used, the kind of network connection to employ, the locations to test from, whether or not the browser’s cache is empty or full, how frequently to take the measurements, and more. They are more of a benchmark than a true measurement of real user experience.

Website 133

Website Design Network Best Practices 133

High Scalability

NOVEMBER 25, 2019

He and his colleagues spend their productive hours scaling large distributed file systems. Our only option was to roll up our sleeves and build basic cloud file system components such as object store ourselves. Edge caching. Nginx for disk based caching. Java used to power core file system code. Introduction.

Architecture 52

Architecture Cache Azure Storage 52

Smashing Magazine

JANUARY 11, 2021

Build Optimizations JavaScript modules, module/nomodule pattern, tree-shaking, code-splitting, scope-hoisting, Webpack, differential serving, web worker, WebAssembly, JavaScript bundles, React, SPA, partial hydration, import on interaction, 3rd-parties, cache. This improves page load time and caching during navigations.

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JANUARY 6, 2020

Geekbench CPU performance benchmarks for the highest selling smartphones globally in 2019. The idea is quite straightforward: Push the minimal code needed to get interactive for the initial route to render quickly, then use service worker for caching and pre-caching resources and then lazy-load routes that you need, asynchronously.

Performance 145

Performance Cache Network Metrics 145

SQL Server According to Bob

JANUARY 11, 2020

​​ Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Servers 40

Servers Cache Database Media 40