Find Slow Queries

SQL Performance Tuning: 7 Practical Tips for Developers

Matt Watson Developer Tips, Tricks & Resources, Popular

Being able to execute a SQL performance tuning is a vital skill for software teams that rely on relational databases. Vital isn’t the only adjective that we can apply to it, though. Rare also comes to mind, unfortunately. Many software professionals think that they can just leave all the RDBMS settings as they came by default. They’re wrong. Often, the …

Free NHibernate Profiler to View SQL Query Performance

Carlos Schults Developer Tips, Tricks & Resources

Let’s begin with a little thought experiment. Imagine you’re responsible for the next release of your company’s flagship product, and today is the big day: you’re about to give a demo presentation for all the big shots in the company. The CTO is obviously there, since she’s your boss. The CEO is there as well, along with the VP of …

PostgreSQL Performance Tuning Tutorial

Lou Bichard Developer Tips, Tricks & Resources

 Today we’re going to look at performance tuning PostgreSQL. PostgreSQL is an advanced open source SQL database. Setting up the database is just the first step. With every table you add and every query you run, your databases will require maintenance and updates to ensure that they continue to run efficiently. Although PostgreSQL does make a lot of optimizations for you, there …

Find and fix issues in Hibernate with Retrace

How to Find Hibernate Performance Issues in Development and Production

Thorben Janssen Developer Tips, Tricks & Resources

The Java Persistence API (JPA), and Hibernate ORM as its most popular implementation are used in most Java applications to interact with a relational database. The main reason for their popularity is that they use object-relational mapping to abstract the database interactions and make it very easy to implement simple CRUD operations. But this abstraction also has its downsides. Hibernate …

What are CRUD Operations?

What are CRUD Operations: How CRUD Operations Work, Examples, Tutorials & More

Stackify Developer Tips, Tricks & Resources

If you’ve ever worked with a database, you’ve likely worked with CRUD operations. CRUD operations are often used with SQL, a topic we’ve covered in depth (see this article, this one, and this one for some of our recent SQL tips and tricks). Since SQL is pretty prominent in the development community, it’s crucial for developers to understand how CRUD operations …