The database was sql server. From what I've read so far I agree that those are the default settings. I don't know exactly why the speed improved. The profiled timings of the calls even with the same connection string do have some significant variation. There is more work to do, but after 4 tries each the fastest time (14.7) occurred with the addition and the worst (21.1) without it.
Andrea Tassinari wrote: > > > On Thu, August 6, 2009 11:21 pm, Jonathan Lim said: >> >> 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. > > which database are you using? Correct me if I am wrong but "Max Pool > Size=100;Pooling=true" are exactly the default values for the SqlClient, > so the pooling should be enabled without specify then in the connection > string. > > http://msdn.microsoft.com/en-us/library/8xx3tyca%28VS.71%29.aspx > > > -- > AndreaT > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-cs-h...@ibatis.apache.org > > > -- View this message in context: http://www.nabble.com/speeding-up-web-service-using-ibatis-tp24852995p24869146.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
