Read MySQL index structure and query optimization

Review the previous: Learn the explain tool of MySQL (at the same time, it is emphasized again that these articles on MySQL are based on version 5.7, and the relevant conclusions and conclusions are not necessarily applicable to other versions) MySQL official documents( https://dev.mysql.com/doc/refman/5.7/en/optimization-indexes.html )There is ...

Posted by jamkelvl on Mon, 16 May 2022 11:45:34 +0300

AOP aspect oriented programming: the use of Aspect J

For AOP aspect oriented programming, there are many types of AOP framework at present. For details, please refer to the article: Talk about Android AOP technical scheme Here we will explain the AOP framework: the use of AspectJ. 1. Section oriented programming 1.1 programming paradigm In the current programming language, the programming ...

Posted by jordz on Sun, 15 May 2022 06:25:06 +0300

. NET performance optimization - splicing strings using ValueStringBuilder

preface The Tips I share with you this time are used in string splicing scenarios. We often encounter many scenarios where short strings need to be spliced. String is not recommended in this scenario Concat means using the + = operator. At present, the most recommended solution is to use StringBuilder to build these strings. Is there any faster ...

Posted by pythian on Wed, 11 May 2022 04:29:27 +0300

SQL optimization case: OR condition optimization

Following is an introduction to the previous article, SQL Optimization Case (1): Implicit Conversion, which focuses on OR optimization. In MySQL, the same query condition, if the OR s are transformed in the SQL statement, the results of the query will be different. In many complex cases, poor index selection may be a potential performance hazar ...

Posted by dewbie on Mon, 09 May 2022 19:28:01 +0300

The speed is increased hundreds of times, and the application of the data structure in practical work is recorded once

During this period of time, I wrote a lot of source code analysis. This article wants to change the taste and share with you a case I encountered in my work. After all, as a part-time worker, in addition to looking at the source code at work, bricks still have to be moved. This article will share a story of using appropriate data structures to ...

Posted by ready2drum on Fri, 06 May 2022 07:42:09 +0300

content-visibility - With just one line of CSS code, the rendering performance of long list pages can be improved by several times!

I believe most developers have encountered long list web pages. When there are too many DOM elements, the browser rendering will be very slow, which greatly affects the user experience. Therefore, we will often use different methods such as virtual scrolling, paging, and pull-up to load more. The ideas of these methods are the same. They only r ...

Posted by jursten on Sat, 30 Apr 2022 00:57:58 +0300

The 10th Session of mysql - shardingsphere JDBC table and database splitting practice of mysql+springboot

As a back-end development, there should be more than a few people who have used mycat. Talk about the problems encountered by the author using mycat! A separate service is required. For the concept that we only have a series of connection addresses, sometimes we don't know when we hang up (because it is deployed by operation and maintenance, an ...

Posted by salmon on Wed, 20 Apr 2022 13:22:14 +0300

Advanced use of Jmeter: BeanShell implements interface pre and post operations

1, Background When we use Jmeter for stress testing or interface testing, in addition to the simplest direct request to the interface, we often need to carry out some pre operations on the interface: such as generating test data in advance, and some post operations: such as extracting the value of a field in the interface response content. Tak ...

Posted by EXiT on Thu, 07 Apr 2022 04:04:25 +0300

Vue source code compilation optimize s AST tree

Three source optimization tree The learning content and article content are from Mr. Huang Yi Mr. Huang Yi's muke.com video tutorial address: Uncover the source code of Vue.js2.0, Address of teacher Huang Yi's hook education course: Vue.js 3.0 core source code analysis The source code analyzed here is Vue of Runtime + Compiler js Debugg ...

Posted by PatelNehal on Sun, 03 Apr 2022 03:44:15 +0300

This article explains the past and present life of Android lightweight storage scheme in detail

Storage scheme is a very important module in Android development. Here is a big man's past and present life of Android lightweight storage scheme. I hope it will be helpful to your study and work. Original address: https://juejin.cn/post/6934494768185475079 background For Android lightweight storage solutions, there are shared preferences ...

Posted by maGGot_H on Sat, 02 Apr 2022 00:12:26 +0300