• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate and Teradatabase Performace

 
Chandramouli Jambunathan
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

We are using Hibernate and Teradata database as the backend in our application and facing high performace issue during joining with multiple tables. I am not using native sql concept but using Category for the retrieval. Have anybody realised the same problem earlier with Teradabase?

What is the Hibernate compatibility with the Teradata database?

Please provide some inputs..

Thanks,..
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you profiled the SQL being issued to find out what the problem may be? Have you tuned your database?

Out the box Hibernate should perform OK assuming you have not mapped anything in an unperformant way (not using proxies and lazy initialisation and the like). But you should expect to have to do some tuning.
 
Chandramouli Jambunathan
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Thanks for the reply. But we are not using SQL/HQL for the execution, we execute using Category and the query is automatically geberated. The mapping also checked and it looks fine.

As Teradata database is majorly used for Datawarehousing and tables does not have the primary key and relations to others. It deals with lakhs of records and first time i am using this DB with Hibernate. The DB also recently listed in the Hibernate DB support list.. I am new to Teradabase using Hibernate. Wanted to know anybody used Teradatase with Hibernate and experienced any performance issue..

Thanks..
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic