Remove 2019 Remove Servers Remove Testing Remove Tuning
article thumbnail

What is web application security? Everything you need to know.

Dynatrace

A web application is any application that runs on a web server and is accessed by a user through a web browser. Application security tests can be used to tell developers when they have introduced vulnerabilities into the application they’re building. What is web application security? Why is web application security important?

article thumbnail

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality

Scalegrid

Compare ease of use across compatibility, extensions, tuning, operating systems, languages and support providers. Recognized as the fastest growing database by popularity, PostgreSQL was named the DBMS of the year in both 2018 and 2017 by DB-Engines, and continues to grow in popularity in 2019. Compare Ease of Use.

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

Finding Distinct Values Quickly

SQL Performance

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. Test Environment. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. Row Store Clustered Index.

Servers 86
article thumbnail

Percona Database Performance Blog 2018 Year in Review: Top Blog Posts

Percona

We look forward to providing you with even better articles, news and information in 2019. As 2018 moves into 2019, let’s take a quick look back at some of the most popular posts on the blog this year. Linux OS Tuning for MySQL Database Performance. AMD EPYC Performance Testing… or Don’t get on the wrong side of SystemD.

article thumbnail

What Is PostgreSQL Used For?

Percona

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. Then those tools have to be configured and tested to work together. PostgreSQL hasn’t just been a concern to its competitors; it’s swooped past most of them. It all helps ensure the cluster’s peak performance.

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. 2019-02-22T18:26:25 Creating triggers. 2019-02-22T18:27:14 Created triggers OK.

C++ 101
article thumbnail

Understanding Execution Plan Operator Timings

SQL Performance

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). SQL Server makes some timing adjustments in parallel plans to promote consistency, but they are not perfectly implemented.

Servers 95