-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Efficiency of <query> in Mapping files?
PostPosted: Wed Oct 17, 2007 1:13 pm 
Newbie

Joined: Tue May 02, 2006 9:56 pm
Posts: 6
I was wondering how efficient using prepared statements in the mapping file vs prepared statements in code?

We have an application that has roughly 200+ prepared statements and it takes a while to load, up to 50 seconds or so but when I removed those statements the app loaded up much quicker....probably 20 seconds or so. So its seems like an obvious that the prepared statements caused longer load times.
So my question is how does this affect runtime and application resources? Are the longer deployment times a trade-off for better DB query and application performance? I ask because we are potentially in an environment where we would need to deploy multiple instances of this app on a single server and I'm trying to figure out how badly all these XML prepared statements are going to hurt server resources and possibly not less us deploy as many as we would like.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.