Over a million developers have joined DZone.

Diving Into Database Performance

DZone's Guide to

Diving Into Database Performance

Database performance is crucial to the quality of your insights. Check out this article for plenty of resources from DZone and beyond. After all, one does not simply fix, "It's slow."

· Database Zone ·
Free Resource

MariaDB TX, proven in production and driven by the community, is a complete database solution for any and every enterprise — a modern database for modern applications.

Welcome to the first Database Deep Dive of 2018! In our last Database deep dive, we talked about database administration and all the things you need to know about it, such as what it takes to be a DBA, what's been going on in the world of database administration, and more. This time, we're going to talk about one of the most popular topics in the Database Zone: database performance. Get cozy and read on to get your dose of database performance knowledge from DZone and beyond.

Image title

Database Performance Perfection

Check out some of the top database performance-related articles on DZone to help you perfect the performance of your database. These articles cover a wide range of topics from the world of database performance, so hold on to your DBA hat!

  1. 6 Simple Performance Tips for SQL Statements by Mpumelelo Msimanga. Even though this article was published back in 2014, its sentiments still ring true today. This article provides a checklist to go through when you're checking the performance of your database.

  2. Database Performance Testing With Apache JMeter by Rathnadevi Manivannan. Learn how to construct your database performance testing plan with all the most important elements, including a thread group, JDBC request, and summary report.

  3. SQL Performance Tuning: Query Optimization 101 by Bikram Sinha. Get some best practices for using SQL queries form a performance perspective, using Oracle as a primary reference.

  4. Why Be Normal? Your Database Performance Depends On It by Scott Stone. In the world of database performance, "normal" is a highly prized goal. It means that nothing extraordinary is happening that requires intervention or diagnosis.

  5. The Key to Distributed Database Performance: Scalability by Darren Perucci. Learn why a key consideration in moving to distributed databases is ensuring that your databases are scalable enough to delivery the technology's cost and performance benefits in the first place.

PS: Are you interested in contributing to DZone? Check out our Bounty Board, where you can apply for specific writing prompts and win prizes! 

Resourceful Round-Up

We've scoured the web for some database performance resources that are sure to pique your interest. 

Dive Deeper Into Database Performance

DZone has Guides and Refcardz on pretty much every tech-related topic, but if you're specifically interested in database performance, these will appeal the most to you. 

  • The DZone Guide to Databases: Speed, Scale, and Security. Advances in database technology have traditionally been lethargic. That trend has shifted recently with a need to store larger and more dynamic data. This DZone Guide is focused on how to prepare your database to run faster, scale with ease, and effectively secure your data.

  • NoSQL and Data Scalability. While not specifically about database administration, this DZone Refcard covers loads of information imperative to any DBA — such as the range of NoSQL database types available today, whether NoSQL is right for you, and several real-life use cases for using a NoSQL database.

That's all for this month's deep dive! What would you like to learn about next time? Let us know in the comments!

MariaDB AX is an open source database for modern analytics: distributed, columnar and easy to use.

database ,database performance ,sql ,performance testing ,query optimization ,scalability ,jmeter ,postgres

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}