• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

Statements executing VERY slowly

 
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all

Statements we execute against the database are VERY SLOW INDEED.

The sql is generated by Hibernate.
The application server is Webshpere Community Edition.
The database is Sql Server 2005.
The database driver is the jTDS driver.

If we take the sql generated by hibernate and execute it directly against the database, the query flies along.
If we take the sql and execute it as a prepared statement through a jdbc connection, again it flies along.
When we use the service that ultimately calls the Hibernate classes, we are waiting in excess of 60 seconds for the query to complete.

Does anyone have any pointers that can help remedy this?

I've also posted a similar question here, on the Websphere Forum
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Are you running out of memory? Check the amount of virtual memory your JVM is using - you may need to increase it.

Also, what is your network connection between your Hibernate app. and the DB like?
reply
    Bookmark Topic Watch Topic
  • New Topic