高并发数据库控制访问代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】高并发数据库控制访问

作者:大道容人 / 发布于2015/3/12/ 964

代码的作用在于保证在上端缓存服务失效（一般来说概率比较低）时，形成倒瓶颈，从而能够保护数据库，数据库宕了，才是大问题（比如影响其他应用）。


	public static long currentValidSessionID = -1;
	public static object databaseDoor = new object();
	void readDatabase(Request currentRequest)
	{
	 // use currentValidSessionID to filter out other requests came in during the execute time gap
	 if (currentValidSessionID == -1)
	 {
	 // use object-lock to filter out other requests came in during the variable change time gap.
	 lock (databaseDoor)
	 {
	 // now there is only very little number of requests can reach below codes.
	 if (currentValidSessionID == -1)
	 { // now there will be only one request can access the database
	 currentValidSessionID = currentRequest.SessionID;
	 }
	 }
	 }
	
	
	 if (currentValidSessionID == currentRequest.SessionID)
	 { // here is the one !
	 try
	 {
	 // use transaction to guarantee the execute time to void block
	 // access database codes go here
	 }
	 catch()
	 {
	 // exception codes go here
	 }
	 finally
	 {
	 currentValidSessionID = -1; // recover to original state
	 }
	 }
	}

试试其它关键字

　高并发　　数据库控制　

同语言下

可能有用的

大道容人贡献的其它代码(1)

.高并发数据库控制访问