shardingsphere5.0 解决第一次执行sql慢的问题

springboot项目集成了shardingsphere5.0项目启动后，第一次执行sql查询特别慢，而之后的查询就响应比较快速。此处用了一个投机取巧的方法解决第一次查询慢的问题，就是项目启动后，执行一个select x 命令

import org.antlr.v4.runtime.tree.ParseTree;
import org.apache.shardingsphere.infra.database.type.DatabaseType;
import org.apache.shardingsphere.infra.database.type.DatabaseTypeRegistry;
import org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.sane.JDBCSaneQueryResultEngineFactory;
import org.apache.shardingsphere.infra.parser.sql.SQLStatementParserEngineFactory;
import org.apache.shardingsphere.sql.parser.api.CacheOption;
import org.apache.shardingsphere.sql.parser.api.SQLParserEngine;
import org.apache.shardingsphere.sql.parser.api.SQLVisitorEngine;
import org.apache.shardingsphere.sql.parser.api.parser.SQLParser;
import org.apache.shardingsphere.sql.parser.core.ParseASTNode;
import org.apache.shardingsphere.sql.parser.core.SQLParserFactory;
import org.apache.shardingsphere.sql.parser.core.database.parser.DatabaseTypedSQLParserFacadeRegistry;
import org.apache.shardingsphere.sql.parser.core.database.visitor.SQLVisitorFactory;
import org.apache.shardingsphere.sql.parser.core.database.visitor.SQLVisitorRule;
import org.apache.shardingsphere.sql.parser.spi.DatabaseTypedSQLParserFacade;
import org.springframework.beans.factory.InitializingBean;
import org.springframework.stereotype.Component;

import java.util.Properties;

/**
 * 提前解析一条公共的 sql 项目启动后解决sharding框架，第一次解析sql慢的问题
 */
@Component
public class ShardingLoadConfig implements InitializingBean {
    @Override
    public void afterPropertiesSet() throws Exception {
        System.out.println("ShardingLoadConfig....");
//        // 提前解析一条公共的 sql
        String databaseType = "MySQL";
        String sql = "select 'X'";
        //方法1
        DatabaseTypedSQLParserFacade sqlParserFacade = DatabaseTypedSQLParserFacadeRegistry.getFacade(databaseType);
        SQLParser sqlParser = SQLParserFactory.newInstance(sql, sqlParserFacade.getLexerClass(), sqlParserFacade.getParserClass(), true);
        ParseASTNode execute = (ParseASTNode)sqlParser.parse();
        ParseTree parseTree = execute.getRootNode();
        SQLVisitorFactory.newInstance(databaseType, "STATEMENT", SQLVisitorRule.valueOf(parseTree.getClass()), null);

        //方法2
//        CacheOption cacheOption = new CacheOption(128, 1024L, 4);
//        new SQLVisitorEngine(databaseType, "STATEMENT", new Properties())
//                .visit(new SQLParserEngine(databaseType, cacheOption, true)
//                        .parse(sql, true));

    }
}

参考文档： https://blog.csdn.net/wydyd110/article/details/116423172