Stored Procedure | access | speed | Page when there is a large number of reuse statements in the executed SQL statement, that is, the SQL statements executed by page A and page b
There is a large number of repetitive operations, there is an intersection, stored procedures can improve the speed of web browsing.
First, if so, in the preparation process, as far as possible to improve the process of particle size, that is, as far as possible to refine, do
To write some atomic processes, and then call them layers, build the application, like building blocks. Due to charge
Use the reusable code, which will improve the speed of Web Access.
If the SQL statement in the page is very verbose, when using the stored procedure, the transmission will only be called
In a word, instead of having to transfer a large section of SQL statements across the network, this can increase access speed;
The readability of the program, the error rate of the combination of SQL statements and variables will be reduced.
Third, if in the page, there is the transmission of binary data, the SQL statement is the first binary data conversion to
characters, which can be a waste of time, but only when the binary data is transferred.
Four, stored procedures in the server section of the compilation, reducing the burden on the browser, but at the same time aggravating the server's
Burden, this also needs attention.
In short, pros and cons, specific whether to do, but also weigh.