外文翻译--关于数据库死锁的知识-数据库(编辑修改稿)

外文翻译--关于数据库死锁的知识-数据库(编辑修改稿)内容摘要：

llion 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。 Second, the list box have growth time operation of the inquiry. The two parties face touch together, may cause the application of improving the running time process query. And the other user queries, such as the system administrator need to maintain customer information, and cause congestion. So, in the application design, the child inquires the best less. And the child inquires the list box and use at the same time, more need to ban. If you can39。 t avoid it, should be in application realize caching mechanism. That way, the applications need to sales representative information, will from application cache made, not every time to check the database. At the same time, can be in the list box design to search function. When there is a change to the user information, such as the system administrator to join a new sales representatives. In no again before inquires, because of their application is achieved in the cache data, so not just updated content. At this time, users will need to run to inquires the function, let the foreground application from a database query information again. This kind of design, can increase the list box and the son of the execution time inquires, effectively avoid congest。