外文翻譯--關(guān)于數(shù)據(jù)庫(kù)死鎖的知識(shí)-數(shù)據(jù)庫(kù)-文庫(kù)吧
2025-04-17 07:53 本頁(yè)面
【正文】 o watch the lock, can block other inquiries. So often, don39。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。t let the user input content. Although in the affairs of the process with sex, can let the user participation, in order to improve the interactivity. But, we don39。t remend the database administrator tend to do so. Because if the user in affairs during the exec ution of the input and number, will extend the affairs of the execution time. Although people smarter, but the response speed still don39。t have a puter so fast. So, during the implementation of the user participation to let the process, will extend the affairs of waiting time. So unless there is a special needs, not in the application39。s execution process, reminds the user input parameters. Some affairs of the executive must parameters, best provide beforehand. If can through the variables in the parameters such as need to go in. Suggest three: make affairs as far as possible the brief. The author thinks that, database administrator should put some problem is simplified. When a need to many SQL statements to plete, might 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 mi
畢業(yè)設(shè)計(jì)相關(guān)推薦
鄂ICP備17016276號(hào)-1