Diving Into Database Performance
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."
Join the DZone community and get the full member experience.Join For Free
Built by the engineers behind Netezza and the technology behind Amazon Redshift, AnzoGraph™ is a native, Massively Parallel Processing (MPP) distributed Graph OLAP (GOLAP) database that executes queries more than 100x faster than other vendors.
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.
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!
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.
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.
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.
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.
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!
We've scoured the web for some database performance resources that are sure to pique your interest.
What you need to know about database performance software by Craig S. Mullins. In this popular TechTarget article, learn about types of database performance management software, when you need database performance tools, what the database performance software market looks like, and more.
Postgres Performance Tuning and Query Planner with Bruce Momjian. In this podcast episode, get a brief history of Postgres, learn about three main areas that affect database performance, and learn how these concepts are used by Postgres to pick query plans.
Database Performance Explained in less than 6 minutes. In this quick, entertaining video, learn about the basics of database performance with a boxing match analogy.
Dive Deeper Into Database Performance
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!
Opinions expressed by DZone contributors are their own.