article thumbnail

A case study of SQL Query tuning in SQL Server

SQL Shack

Gaining experience in SQL query tuning can be very difficult and complicated for database developers or administrators. For this reason, in this article, we will work on a case study and we are going to learn how we can tune its performance step by step. In this fashion, we will understand well how to approach […].

Tuning 91
article thumbnail

Reducing HTML Payload With Next.js (Case Study)

Smashing Magazine

Reducing HTML Payload With Next.js (Case Study). Reducing HTML Payload With Next.js (Case Study). However, in our pages, the case was different as our database stores lots of data, and we need to serve thousands of landing pages at scale. Now it kicks into play in the server. Liran Cohen.

Google 110
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

Reducing High CPU on MySQL: a Case Study

Percona

The server is a small instance: Models | 6xIntel(R) Xeon(R) CPU E5-2430 0 @ 2.20GHz 10GB RAM This symptom can be caused by various different reasons. There could be more, but this particular query was definitely hurting the performance of the server. We needed to reduce the high CPU usage on MySQL. Increase QPS by 2x.

C++ 98
article thumbnail

How to use Server Timing to get backend transparency from your CDN

Speed Curve

Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB). Cue server-timing headers Historically, when looking at page speed, we've had the tendency to ignore TTFB when trying to optimize the user experience. I mean, why wouldn't we?

Servers 57
article thumbnail

Aurora vs RDS: How to Choose the Right AWS Database Solution

Percona

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What we should really compare is the MySQL and Aurora database engines provided by Amazon RDS. How do I choose which one to use?

AWS 52
article thumbnail

Performance Tuning Re-indexing and Update Statistics – A Case Study

SQL Server Performance

Recently we started experiencing a very strange issue in our production reporting environment where the Re-indexing and Update Statistics operation suddenly began taking more than 2 days to complete and was thus causing blockage in the database which in turn caused impairment in application performance.

Tuning 40
article thumbnail

Improving The Performance Of Wix Websites (Case Study)

Smashing Magazine

Improving The Performance Of Wix Websites (Case Study). Improving The Performance Of Wix Websites (Case Study). In order to accommodate such a high number of test runs without negatively impacting build time, Perfer executes the performance measurements in parallel on a cluster of dedicated servers called WatchTower.

Website 126