Percona

MAY 1, 2023

Connection pooling: Minimizing connection overhead and improving response times for frequently accessed data by implementing mechanisms for connection pooling and caching strategies. PostgreSQL performance optimization is an ongoing process involving monitoring, benchmarking, and adjustments to maintain high-performing PostgreSQL databases.

Tuning 52

Tuning Efficiency Database Performance 52

MachMetrics

DECEMBER 14, 2019

Similar to our article Average Page Load Times for 2018 , we’ll go over the averages for metrics and help you determine if your site is faster or slower than average. By analyzing the data from Backlinko.com and their Page Speed Stats article, we’ll look to answer these questions: What size should be a website be?

Best Practices 105

Best Practices Speed Mobile Google 105

Percona

AUGUST 31, 2018

The PostgreSQL buffer is called shared_buffer which is the most effective tunable parameter for most operating systems. This parameter sets how much dedicated memory will be used by PostgreSQL for cache. It’s low because certain machines and operating systems do not support higher values. wal_buffers.

Tuning 57

Tuning Database Performance Benchmarking 57

SQL Performance

DECEMBER 17, 2019

You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario. Microsoft's Mine Tokus has a good article where she ran a series of scaled down TPC-E benchmarks against an E64s_v3 VM that was using the older Broadwell processor.

Azure 72

Azure Virtualization Servers Storage 72

SQL Server According to Bob

JANUARY 11, 2020

The purpose of this paper is to explain the Input/Output (I/O) requirements for SQL Server database file operations so that vendors and customers can evaluate and adjust their environments to meet the needs of SQL Server. Stable media is commonly physical disk storage, but other devices and certain caching facilities qualify as well.

Servers 40

Servers Cache Media Hardware 40

SQL Server According to Bob

JANUARY 11, 2020

Time of Last Access The time of last access is a caching ​​ algorithm ​​ that enables ​​ cache ​​ entries to be ordered by their ​​ access times.

Servers 40

Servers Cache Database Media 40

Smashing Magazine

JUNE 2, 2021

Today, the website is much faster and ranks highly in various showcases and benchmarks. In this article, I’ll highlight some of the work we did and how we were able to achieve our speed. For this article, we will focus on the first three and the performance adjustments for these. Large preview ). The checkout is its own beast.

Performance 115

Performance Cache Website Mobile 115