HI All,

how to increase the speed of hibernate.

when i executes the hibernate query it takes so much of time to get the result.

for eg: if it returns 30+ rows it takes 1 min. and it shows those query in console since i have given <show sql=true>

is it because i am printing the queries..

how to increase the speed????

thanks in advance
balag

There's nothing in Hibernate that causes that much of a slowdown. I can produce about 50k/sec of show_sql="true" + "log4j.logger.org.hibernate.type=DEBUG, DBLog" log output, so long as the log output is going to a file and not the console. Are you doing queries/inserts to large unindexed tables? I'd definitely run some DB profiling before blaming Hibernate..