Remove Article Remove Benchmarking Remove Cache Remove Storage
article thumbnail

Five Data-Loading Patterns To Improve Frontend Performance

Smashing Magazine

On your first try, you can use it as a benchmark for optimizations later. Active Memory Caching. When you want to get data that you already had quickly, you need to do cachingcaching stores data that a user recently retrieved. Caching partially stores your data and is not used as permanent storage.

Cache 125
article thumbnail

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

Percona

Inadequate CPU, memory, or storage can lead to bottlenecks and performance degradation, so remedying these issues involves upgrading hardware or optimizing resource utilization through query and server configuration adjustments. Avoid over-indexing, which can bloat storage and slow writes.

Tuning 52
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Percona

Hardware optimization : You need to ensure that the CPU, memory, and storage components meet the performance requirements of the database 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
article thumbnail

Redis vs Memcached in 2024

Scalegrid

Key Takeaways Redis offers complex data structures and additional features for versatile data handling, while Memcached excels in simplicity with a fast, multi-threaded architecture for basic caching needs. Redis is better suited for complex data models, and Memcached is better suited for high-throughput, string-based caching scenarios.

Cache 130
article thumbnail

How to improve Redo, Transaction Log and WAL throughput for HammerDB benchmarks

HammerDB

This post at an entry-level discusses the options you have to improve log throughput in your benchmark environment. . To illustrate the data reads on Oracle we can flush the buffer cache. Consequently we now need to increase the buffer cache in size if we are to see more CPU activity. so what are your options? PostgreSQL.

article thumbnail

Azure Virtual Machines for SQL Server Usage

SQL Performance

This removes the burden of purchasing and maintaining your hardware, storage and networking infrastructure, while still giving you a very familiar experience with Windows and SQL Server itself. There are also large differences in storage capacity and throughput between these extremes. GHz, 128MB of L3 cache, 128 PCIe 4.0

Azure 72
article thumbnail

How I Used Brotli to Get Even Smaller CSS and JavaScript Files at CDN Scale

CSS - Tricks

The HBO sitcom Silicon Valley hilariously followed Pied Piper, a team of developers with startup dreams to create a compression algorithm so powerful that high-quality streaming and file storage concerns would become a thing of the past. This article is about my experience using Brotli at production scale. This is all so good.

Cache 79