SQL Performance

JANUARY 11, 2021

So when their compiled application sends ad hoc queries to SQL Server, particularly as a prepared statement, and when we don't have the freedom to add or change indexes, several tuning opportunities are immediately off the table. We'd definitely prefer to change the query, or the indexes, if we could. TheThings. (

Cache 59

Cache Tuning Database Performance 59

Percona

JULY 6, 2023

Next is the table definition. Index Scan It might be the scan method you think about when hearing something like, “Hey, this query is doing good; it uses the index… ” This method is the basic definition of accessing the data by an index. Tune the random_page_cost parameter.

Best Practices 87

Best Practices Tuning Database Testing 87

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. Cache Access Pattern Depending on the memory access pattern and working set size, an additional 1% to 10% overhead can occur at a certain syscall rate. and 4.14.12

Performance 75

Performance Benchmarking Cache Tuning 75

MachMetrics

JULY 31, 2020

But we’ll definitely help you decide which is the best choice for your situation. It also offers 9 levels of compression, so that the amount of compression and the time it takes to compress can be fine-tuned. Many caching plugins like WPRocket also offer Gzip compression right out of the box. OK, not really.

Speed 67

Speed Servers Google Tuning 67

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. Cache Access Pattern Depending on the memory access pattern and working set size, an additional 1% to 10% overhead can occur at a certain syscall rate. and 4.14.12

Performance 40

Performance Benchmarking Cache Tuning 40

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

SQL Server According to Bob

JANUARY 11, 2020

Stable media is commonly physical disk storage, but other devices and certain caching facilities qualify as well. Many high-end disk subsystems provide high-speed cache facilities to reduce the latency of read and write operations. This cache is often supported by a battery-powered backup facility.

Servers 40

Servers Cache Media Hardware 40

Smashing Magazine

AUGUST 22, 2021

While a perfect understanding of these concepts is not needed for the rest of this post, having a common high-level definition would be good. As such, tuning congestion logic is usually only done by a select few developers, and evolution is slow. However, I will most definitely do no such thing! Congestion Control.

Performance 106

Performance Network Latency Servers 106

Alex Russell

SEPTEMBER 11, 2014

What matters from here is that we take the opportunity to apply Jeremy’s finely-tuned sense of taste and focus it on specific outcomes, not the entire distribution of possible outcomes. Service Workers do this for network caching and AppCache. > This invokes magical behavior in some browsers.

Google 41

Google Tuning Cache Design 41

Tim Kadlec

JANUARY 31, 2019

I can definitely see the case for making sure that a PWA doesn’t violate these restrictions before allowing it to be added to the homescreen and get all the juicy benefits PWA’s provide. Thanks to Yoav Weiss and Alex Russell for helping me fine-tune some of my thoughts on this.

Tuning 76

Tuning Cache Development Performance 76

Smashing Magazine

AUGUST 9, 2021

However, many other devices are sitting between the client and the server that also have their own TCP code on board (examples include firewalls, load balancers, routers, caching servers, proxies, etc.). On top of that, QUIC allows for the easy definition of extensions, so even more use cases can be implemented. Stay tuned! (vf,

Transportation 145

Transportation Internet Internet Network 145