外文翻譯--關(guān)于數(shù)據(jù)庫死鎖的知識-數(shù)據(jù)庫-wenkub
2023-05-19 07:53:32 本頁面
【正文】 all sales representative inquires information (if the application is not involved in the cache). On one hand, the son of nature, would be speed query slow。t take long time running decision support search and online transaction processing inquires the mixed together. When database meet blocked, often need to check the application submitted to the SQL statement itself, and check and connection management, all the results do processing and other relevant application behavior. Usually, the lock for to avoid the conflict in the jam, the author has the following Suggestions. Suggest a: after the pletion of the extraction of all query results do. Some applications in order to improve the response speed of the user inquires, will have the option of extraction need record. The smart looks very reasonable, but, but will cause more waste. Because inquires not timely and fruit extraction of words, the lock cannot be released. When others inquires the data, will be happening. So, the author suggest in application design, database query for record to the extraction of in time. Through other means, such as adding inquires the conditions, or the way backstage inquires, to improve the efficiency of the inquires. At the same time, in the application level set reasonable cache, and can also be very significantly improved query efficiency. Suggest two: in the transaction execution don39。外文翻譯 About the database of the knowledge of the deadlock Database itself provides lock management mechanism, but from a hand, database is the client applications puppet, this is mainly because the client to the server has plete control of the gain of locks ability. The client in enquiries in the request and the way to query processing tend to have direct control, so, if we application design reasonable enough, then appear database is normal phenomenon dead lock. Below are listed some easy to have locked application examples: A, the client cancel inquires no roll back after practice. Most of the application is inquires often happens homework. However, users through the front desk the client application inquires the backend database, sometimes will cancel inquires for any variety of reasons. If the user to open the window after mouth query, because users find reflect crash or slow pelled to cancel the query. But, when the client when cancel inquires, if not add rollback transaction statement, then at this time, because the user has to the server sends the inquiry39。t let the user input content. Although in the affairs of the p
畢業(yè)設(shè)計(jì)相關(guān)推薦
鄂ICP備17016276號-1