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?
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.
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..
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads