July in Performance: SQL, Java Memory, and Python Performance

We take a look at the best articles on Performance on DZone from June, some interesting pieces from others sites, and great performance gigs and publications featured on DZone. 

An Encore for DZone's Top Performance Performers: 

SQL Performance Tuning: Top 5 Ways to Find Slow Queries - A look at the five best ways developers can go about finding slow SQL queries in their code, such as SQL DMVs and Query Reporting via APM solutions. 

Java Memory Consumption in Docker and How We Employed Spring Boot - One dev tells how his team dealt with Java code that was consuming far too much memory by using Sprint Boot.  

Mistakes Using Java Main and Examples of Coding Without Main - A tester explains why he's (almost) never uses Java main methods in his code, and how he's gotten away with it. 

What's the Difference Between Automated Testing and Manual Testing? - A look at the pros and cons of both Automated and Manual testing, and the scenarios in which each best applies. 

Python and Performance - A quick discussion of several ways developers can optimize Python based web applications and the performance of URLs. 

The Best From the Rest: 

A Quick Start Guide to Learning Performance Testing, by The PerfBytes Community, July 2017.

CSS vs. X Path, by Elemental Selenium Team, July 2017.

Dropdown Alternatives for Better (Mobile) Forms, by Zoltan Kollin, July 4, 2017.

Find Your Next Great Performance Gig

Lead Performance Engineer
Couchbase
Location: Mountain View, CA, United States
Experience: 10+ years of experience in performance engineering. You'll be working with complex distributed systems, large clustered datasets, and databases, and lead the efforts to increase and optimize system and product performance. Necessary skills include Performance testing tools, Java memory management, and system monitoring tools. 

Lead Site Reliability Engineer 
Papertrail (SolarWinds)
Location: San Francisco, CA, United States or Remote
Experience: You'll be leading a small, distributed SRE team, to help build, improve, and manage Papertrail's high-performance processing pipeline. Papertrail's software stack is largely comprised of Ruby, Java, Scala, and (lots of) MySQL. 

Take a Deeper Dive Into Performance With Our Publications

Java Performance Optimization Refcard by Pierre-Hugues Charbonneau.

DZone's Guide to Performance: Optimization and Monitoring featuring articles by Dennis Goodwin, Benedikt Meurer, Oren Eini, Stela Udovicic, Nick Kephart, Alexander Podelko, Heitor Tashiro Sergent, and Omed Habib.