SQL Performance

APRIL 13, 2020

In my last post , I started to outline the process I go through when tuning queries – specifically when I discover that I need to add a new index, or modify an existing one. His version can be used for the plan cache – the only challenge there is the information is transient, so you may not capture every query that uses a particular index.

Tuning 137

Tuning Cache Metrics Testing 137

n0derunner

JULY 23, 2019

Many different queries are executing in parallel, some hitting RAM cache, some hitting storage. The Postgres DB is totally un-tuned and contains purely default settings. The variation in the transaction rate is due to the benchmark itself, the transaction rate is not expected to be uniform.

Benchmarking 76

Benchmarking Storage Tuning Cache 76

Brendan Gregg

FEBRUARY 9, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. Much of my testing was on Linux 4.14.11 Some older kernels have the KAISER patches for Meltdown, and so far the performance overheads look similar. and 4.14.12

Performance 75

Performance Benchmarking Cache Tuning 75

Brendan Gregg

FEBRUARY 8, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. Much of my testing was on Linux 4.14.11 Some older kernels have the KAISER patches for Meltdown, and so far the performance overheads look similar. and 4.14.12

Performance 40

Performance Benchmarking Cache Tuning 40

Smashing Magazine

APRIL 11, 2022

However, developers with a deep understanding of the project may want to improve performance beyond that by doing some fine-tuning under the hood. It’s common knowledge that better website performance results in more conversions, more traffic, and better user experience. Fine-tuning JavaScript Resource Priorities.

Media 70

Media Tuning Metrics Google 70

Smashing Magazine

SEPTEMBER 6, 2021

This approach was touted to be better for fine-grained caching because each subresource could be cached individually and the full bundle didn’t need to be redownloaded if one of them changed. As such, a micro-optimization is, again, how you probably need to fine-tune things on a low level to really benefit from it.

Network 105

Network Servers Cache Traffic 105

High Scalability

NOVEMBER 25, 2019

Edge caching. In general, Egnyte connect architecture shards and caches data at different levels based on: Amount of data. Nginx for disk based caching. We use different types of caching techniques depending on the problem statements. Disk based caching. Hybrid Sync. On prem data processing. Offline access.

Architecture 52

Architecture Cache Azure Storage 52