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 …
SQL Performance Tuning: 7 Practical Tips for Developers
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
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
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: How CRUD Operations Work, Examples, Tutorials & More
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 …
What is SQL Server Express? Definition, Benefits, and Limitations of SQL Server Express
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 …
How to Measure Real World SQL Query Performance for ASP.NET
Almost every ASP.NET application uses some sort of database. But from my experience, the reporting of how long SQL queries take is wildly inaccurate. In this article I’m going to explain why, and show you how you can see the real amount of time that your queries take. This article is really specific to Microsoft SQL Server but the principle …