• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate Search in Action and native SQL dialects

 
Iván Párraga
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I've worked with Hibernate for some projects but I haven't used much more than the basic mappings and queries. However I have some deep knowledge of database tunning and looking at the table of contents of the book, you could think of SQL and database book.

My question is the following. Many of the concepts and optimizations map directly in DBMS and "normal" SQL optimizations. Hibernate tries to be an abstraction of the DBMS but I was wondering how clever it is to take advantage of the native (and different) DBMS and SQL dialects. Will I have to keep profiling the queries generated by the ORM to achieve high performance or can I trust Hibernate?

Cheers,

Iv�n
 
Emmanuel Bernard
author
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What happens is that most queries will be good. Instead of having to rework 30% of your queries, your DBA will be able to focus on 3% of the queries that do no achieve your needs. Hibernate does not generate table or column indexes for you, so your DBA is still needed

But Hibernate Search is about full-text search and does use SQL queries (at least not for the FullText part)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic