Shulou(Shulou.com)06/01 Report--

This article mainly explains the "Weblogic and Oracle DB performance optimization methods", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's ideas slowly in depth, together to study and learn "Weblogic and Oracle DB performance optimization methods"!

The specific practices are as follows:

1. According to the time described in the test report, it is important to identify the bottleneck and determine the optimization plan, which is a guide to action.

two。 Determine the optimization goal, for example, from 100 seconds to 6 seconds

3. By analyzing the network connection point, the data that can be taken out from the server side can be extracted at once, and the logical operation will be carried out on the client side.

4. It is necessary to consider caching the unsaved data of the client in the case of unstable network or abnormal shutdown to ensure the security of user input data.

5. In addition to reducing the number of visits to the middle tier, tables that query data slowly also need to be optimized by adding Index.

According to the above methods, the optimization has basically achieved its goal, which can be summarized as follows:

1. Optimization is endless, we need to find out the bottleneck and determine the optimization goal.

two。 Optimization is not only concerned with the number of connections in the middle tier, but also important for database performance optimization. I have encountered an original query that requires 8000MS, and through the optimization of database and SQL statements, 500MS has been achieved.

3. Optimization needs to be considered in combination with specific procedures and needs to be tracked layer by layer. For example, you need to track where a middle-tier connection is made and whether this connection is necessary.

4. When using caching, you need to consider the consistency of cached data.

5. Save data, save in batch middle tier

6. Independent transactions can be implemented in PL/SQL, which is efficient.

Thank you for reading, the above is the content of "methods of Weblogic and Oracle DB performance optimization". After the study of this article, I believe you have a deeper understanding of the methods of Weblogic and Oracle DB performance optimization, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.