Tag：Counterexample
-
Time：2020-12-14
1. The purpose of the specification: code out high efficiency, code out quality. Combined with our own business scenarios, sort out the specifications suitable for ourselves 2. The current version of the specification mainly includes the following contents: 1、 It’s a good ideaCode coding specification （1） It’s a good ideaBasic norms A. Nomenclature General: the […]
-
Time：2020-11-16
Blog reprinted from30 suggestions for writing high quality SQL The following article comes from the little boy who picks up the snail More practical SQL optimization statements, so I want to share and reprint, also convenient for their own reference The following is the Reprint: In this paper, combined with the example demo, 30 suggestions […]
-
Time：2020-9-29
SQL optimization and diagnosis Explain diagnosis The meaning of each parameter of explain is as follows: Listing explain id The execution number, which identifies the row to which the select belongs. If there is no subquery or associated query in the statement, there is only one select, and each row will display 1. Otherwise, the […]
-
Time：2020-9-7
preface In this paper, combined with the example demo, 30 suggestions on optimizing SQL are elaborated, most of which are summarized in the actual development, hoping to be helpful to you. 1. Try not to use select * in query SQL, but select specific fields. Counter example: select * from employee; Positive examples: select id，name […]
-
Time：2020-4-11
A steed can’t leap in ten steps, but a horse can’t do ten things. Improve the quality of code, optimize performance, the key is to adhere to! If you work hard to eliminate the “bad taste” of code and persist in accumulation, you can not only improve your coding level, but also make the code […]
-
Time：2020-3-8
Original link: https://github.com/ant-move/t This is a small program style guide launched by the Antmove team. This guide combines the WeChat small program, the Alipay Mini program, and the Baidu small program three dimension program framework characteristics to precipitate the development practice guide. The aim is to establish a development specification applicable to the small program […]
-
Time：2020-1-27
When writing SQL statements, we often focus on the execution results of SQL, but do we really focus on the execution efficiency of SQL and the writing specification of SQL? The following dry goods sharing is summarized in the actual development process, I hope to help you! 1. Limit paging optimization When the offset is […]
-
Time：2020-1-8
Summary The application scenarios of Web API are very rich, such as: opening the functions or data of the existing system to partners or ecosphere; publishing the widgets that can be embedded into other web pages; building web applications that are separated from the front and back ends; developing mobile applications across different terminals; integrating […]
