Couple of things. What database are you backing this against? Do you have connection pooling enabled?
On Thu, Aug 6, 2009 at 12:34 PM, Jonathan Lim <j...@ueic.com> wrote: > > Hi, > > I'm a relative iBatis novice. The guy who knew much about iBatis left the > company about 3 years ago. > > We have iBatis.Net DataMapper 1.5.1 running on a Windows Server 2003 behind > some web services. > > We're having some trouble with IIS and/or iBatis and I was wondering if you > could point me in the right direction. > > The problem is we would like to quickly run multiple instances of a > repetitive web service query. > > A single call takes about half a second currently. > > Separating the ibatis calls into a regular multithreaded app and then > profiling with 10 threads shows the section of the code involved with > opening a connection takes about 30% of the time. These should be the > relevant parts: > > public static volatile ISqlMapper mapper = > IBatisNet.DataMapper.Mapper.Instance(); > > mapper.OpenConnection(connStr); > > At 30% this routine has the highest percentage time usage, but I don't see > any obvious way of avoiding it. > > Any suggestion would be appreciated. > > Thanks, > Jonathan > -- > View this message in context: > http://www.nabble.com/speeding-up-web-service-using-ibatis-tp24852995p24852995.html > Sent from the iBATIS - User - Cs mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-cs-h...@ibatis.apache.org > > -- Michael J. McCurrey Read with me at http://www.mccurrey.com http://chaoticmindramblings.blogspot.com/