How to Find Hibernate Performance Issues in Development and Production

How to Find Hibernate Performance Issues in Development and Production

Thorben Janssen Developer Tips, Tricks & Resources

The Java Persistence API (JPA) is used in most Java applications to interact with a relational database. One of its most popular implementations is the Hibernate ORM, because it uses object-relational mapping to abstract database interactions and makes implementing simple CRUD operations very simple. But this abstraction also has its downsides. Hibernate uses a lot of internal optimizations and hides …

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

Setting up the database correctly is just the first step in PostgreSQL performance tuning. With every table you add and every query you run, your databases will require maintenance and updates to ensure ideal PostgreSQL optimization. PostgreSQL optimization is pretty straight-forward, however, there are some things that it needs to know from you, the database admin, in order to run …

What are CRUD Operations?

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

Alexandra Altvater 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 …

SQL Server Express

What is SQL Server Express? Definition, Benefits, and Limitations of SQL Server Express

Alexandra Altvater Developer Tips, Tricks & Resources

If you use SQL in your work, you have several options available, ranging from enterprise options to the free SQL Server Express. Monitoring SQL queries are just one of the many things you can monitor with Prefix, so today we thought we’d take a closer look at how SQL Server Express stacks up to the more advanced, paid options, its …