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