"checkout timeout=0;initial pool size=24;max active size=2000;”+ "max idle lifetime=2880000;”+ "test on borrow=true;test on return=true;test while idle=true;”+ "invalid idle test period=30;supply idle period=20;load balance strategy=polling;max inuse lifetime=0;";
Thread[] _WorkThread = new Thread[_thread]; for (int i = 0; i < _WorkThread.Length; i++)
GBase 8a 程序员手册ADO.NET 篇
- 60 -
南大通用数据技术股份有限公司 { new Thread(WorkThread).Start(enableNewPoolStr); Thread.Sleep(300); } while (true) { if (_finish >= _thread) break; Thread.Sleep(2000); } // release resources GBaseConnection.ClearAllClusterPools(); }
/// /// 主工作线程 /// private void WorkThread(Object _ConnectionStringObj) { String _ConnectionString = (String)_ConnectionStringObj; int times = _runTime; while (times!=0) { try { using (GBaseConnection _ConnObject = new GBaseConnection(_ConnectionString)) { _ConnObject.Open(); using (GBaseCommand _CmdObject = new GBaseCommand()) { _CmdObject.CommandText = "SELECT sleep(1)"; _CmdObject.Connection = _ConnObject; _CmdObject. ExecuteNonQuery(); }