• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate Performance Tuning Online Training question

 
Krystian Kowalski
Ranch Hand
Posts: 76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello and welcome to the ranch !

I am getting feel that hibernate is less popular in past few years and people are not choosing it for new projects - they are going for nosql databases and avoid ORM due to performance. What's your opinion? Is ORM less popular nowadays? Or people just don't know how to tune and use orm properly ?
At my job atm we have a problem with huge raports and joins - flat structure and CQRS would do the work but that's a looooooooooot of work. What would you propose ?
 
Thorben Janssen
Course Creator
Greenhorn
Posts: 3
5
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
From my point of view, no sql database are the new cool thing everyone wants to use in a project. That doesn't mean that they are a good fit for the use case. Quite often they are not!

Relational databases and ORMs are great, if you have a statically defined model for your database and your application. If one or both of that are missing, you should use something else.
If you use an ORM, you need to make yourself familiar with it and learn about its strengths and weaknesses (as with any other tool). If you use Hibernate in the right way, you can most often solve or avoid the performance issues. But if you just copy something from the internet, you have good chances to run into issues as soon as the load or amount of data increases ;)
That is the reason why I created the Hibernate Performance Tuning training.

Wether or not you are using Hibernate, huge reports with complex queries often create performance issues. The first thing I would do is to check which queries are performed by Hibernate and then analyze on the database level which queries are slow. In the ideal world, you do this together with your DBA who can also tell you how to optimize the query. And if you can't transform the optimized query into JPQL, you still can run native SQL queries with Hibernate.

You might want to check these posts about using Hibernate Statistics and useful logging configurations.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic