微型电脑应用

查询优化研究是数据库设计与应用中重点考虑问题,在研究MySql数据库查询优化技术基础上,对配置参数中的数据缓存区和日志缓存区的参数进行优化设置,提高查询效率。针对MySql查询重用技术的特点及存在不规范化sql语言等重用性不高问题,通过设计相关模块改进查询重用功能;增加查询缓冲区的查询执行计划模块来解决查询缓存区大数据量结果集存储问题,并通过实验进行验证,从而改进查询优化效率。

Query optimization research is the key issue in the database design and application.Query optimization technique based on MySql database optimizes the configuration parameters in both data buffer and log buffer in order to improve query efficiency.This thesis resolves the problem of MySql query reusing technology such as non-standardized SQL language with low reusability through the design of relevant modules to improve the query reusing function.Additionally,the thesis increases the execution plan module to solve the query data buffer capacity verified by the experiment,in order to improve the efficiency of query optimization.