外文翻譯--關(guān)于數(shù)據(jù)庫死鎖的知識(shí)-數(shù)據(jù)庫(完整版)
【正文】 ght as well take the task deposition. At the same time, it breaks down into some brief business affairs. If the database a product information table, its record number two million. Now in a management needs, the onetime change one of the one million five hundred thousand record. If through a change affairs, the time is long. If it involves cascade update it, is time the meeting is longer. In view of this situation, we can learn affairs brief words. If the product information, may have a product type field. So in the update data, can we not onetime updates. But through the product category fields to control, to record the iteration points. So every category of update firm consumption of time may be greatly reduces. So although operation, will need more steps. But, can effectively avoid to go to the occurrence of congestion, and improve the performance of the database. Suggest four: child inquires the and list box, had better not use at the same time. Sometimes in the application of design, through the list box can really improve user input speed and accuracy, but, if foreground application does not have buffer mechanism, you often can cause congestion. As in a order management system, may need frequent input sales representatives. In order to user input convenience, sales representative often design into a list box. Every time need to input, foreground application from the background of 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。外文翻譯 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 n
畢業(yè)設(shè)計(jì)相關(guān)推薦
鄂ICP備17016276號(hào)-1