Michael, Thank you for your quick reply. A quick test of adding
Max Pool Size=100;Pooling=true to the connection string did improve the performance of the open connection routine enough that it is no longer the slowest routine. Thanks again for the direction to go towards, Jonathan Michael McCurrey-3 wrote: > > 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/ > > -- View this message in context: http://www.nabble.com/speeding-up-web-service-using-ibatis-tp24852995p24854671.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
