Atitit. View precompiled SQL question mark nature and principle and view native SQL statements

Atitit. To View pre-compilation SQL question mark essence and principle and view native SQL statements

1. Pre-compilation principle. 1

2. PreparedStatement has three major advantages: 1

3. How to look gene SQL 2

1. Hb cfg all debug, cant see ... 2

2. Wsexplorer follow the process crawl pack can be seen: 2

3. Mysql 5. 6 open logs can be seen 2

4. different implementations of Mysql and Msssql 2

4. mysql implementation is a JDBC connected full SQL, can see the easy 2

5.7. The implementation of MSSQL is thought sp ... Only SP 2 is visible

5. Ambiguous option '--log=/var/lib/mysql/mysql.log ' (Log-bin, log_slave_updates) 3

1. Pre-compilation principle.

SQL Language Forest bar Korean compilation changed to machine code ... My SQL is 4GL, so the performance is slower, the precompilation is efficient ...

Each database will do its best to provide maximum performance optimizations for precompiled statements. Because the precompiled statement is likely to be called repeatedly. So the execution code that is compiled by the compiler of the DB is cached, so the next call will not need to be compiled as long as it is the same precompiled statement. As long as the parameters are passed directly into the compiled statement execution code (equivalent to a culvert number) will be executed.

Author:: Old Wow's paw attilax Ayron, email:[email protected]

Reprint please indicate source: Http://blog.csdn.net/attilax

2. PreparedStatementThere are three major advantages:

I. Readability and maintainability of the code.

Two. PreparedStatement the maximum possible performance improvement.

Three. The most important point is a significant increase in security.

3. How to look gene SQL1. Hb cfg all debug, cant see ...

Just question mark:

2. Wsexplorer follow the process crawl pack can be seen:

3. Mysql5. 6 open logs can be seen

General_log=on

General_log_file=c:\mysql.log

Show variables like ' log_% '; View all the Log Command

4. Mysql and Msssqldifferent implementations of4. The MySQL implementation is a JDBC connected full SQL, can view the easy 5. 7. The implementation of MSSQL is thought sp ... can only see SP

5. Ambiguous option '--log=/var/lib/mysql/mysql.log ' (Log-bin, log_slave_updates)

2014-06-26 17:22:59 0 [ERROR] aborting

Google, the solution is the log parameter is currently deprecated, instead of
General_log=on
General_log_file=/tmp/mysql.log