关键词:数据库|时序|生日福利|截止到|性能|提供

庆AIStudio生日福利,赢最强锦鲤鱼

  • 浏览: 13

庆AI Studio生日福利,赢最強锦鲤鱼>>>

BeetlSQL的总体目标是提供高效率的数据库浏览架构,不管要联接哪种数据库,提供一致的撰写编码方法。 截止到M3,现阶段适用数据信息有

传统式数据库:MySQL,MariaDB,Oralce,Postgres,DB2,SQL Server,H2,SQLite,大神通,达梦等互联网大数据:HBase,ClickHouse,Cassandar,Hive物联网技术时序数据库:MachbaseSQL查寻模块:Drill,Presto

在M4环节的总体目标还包含Elastic Search,Derby,SQLite,松子时序库,TD engine时序库,Druid,北京大学金仓,Neo4J

Maven

com.ibeetl beetlsql-all 3.0.0-M3

M3环节依据JMH 子工程项目的变化再开展了一轮检测,性能以下

Benchmark Mode Cnt Score Error UnitsJMHMain.beetlsqlComplexMapping thrpt 5 205.885 ± 57.974 ops/msJMHMain.beetlsqlExecuteJdbc thrpt 5 466.783 ± 29.614 ops/msJMHMain.beetlsqlExecuteTemplate thrpt 5 388.390 ± 32.002 ops/msJMHMain.beetlsqlFile thrpt 5 435.402 ± 62.479 ops/msJMHMain.beetlsqlInsert thrpt 5 211.785 ± 152.417 ops/msJMHMain.beetlsqlLambdaQuery thrpt 5 256.671 ± 32.464 ops/msJMHMain.beetlsqlOne2Many thrpt 5 106.457 ± 16.692 ops/msJMHMain.beetlsqlPageQuery thrpt 5 196.855 ± 30.781 ops/msJMHMain.beetlsqlSelectById thrpt 5 386.098 ± 46.784 ops/msJMHMain.jdbcExecuteJdbc thrpt 5 987.507 ± 49.412 ops/msJMHMain.jdbcInsert thrpt 5 315.066 ± 222.465 ops/msJMHMain.jdbcSelectById thrpt 5 1055.153 ± 105.499 ops/msJMHMain.jpaExecuteJdbc thrpt 5 110.944 ± 17.210 ops/msJMHMain.jpaExecuteTemplate thrpt 5 140.112 ± 12.616 ops/msJMHMain.jpaInsert thrpt 5 79.710 ± 17.193 ops/msJMHMain.jpaOne2Many thrpt 5 97.634 ± 17.690 ops/msJMHMain.jpaPageQuery thrpt 5 120.386 ± 17.249 ops/msJMHMain.jpaSelectById thrpt 5 334.689 ± 20.872 ops/msJMHMain.mybatisComplexMapping thrpt 5 99.133 ± 4.238 ops/msJMHMain.mybatisExecuteTemplate thrpt 5 181.423 ± 23.560 ops/msJMHMain.mybatisFile thrpt 5 133.999 ± 56.998 ops/msJMHMain.mybatisInsert thrpt 5 144.017 ± 15.849 ops/msJMHMain.mybatisLambdaQuery thrpt 5 15.165 ± 2.243 ops/msJMHMain.mybatisPageQuery thrpt 5 63.876 ± 5.651 ops/msJMHMain.mybatisSelectById thrpt 5 203.024 ± 23.581 ops/msJMHMain.weedExecuteJdbc thrpt 5 412.615 ± 31.912 ops/msJMHMain.weedExecuteTemplate thrpt 5 358.685 ± 17.963 ops/msJMHMain.weedFile thrpt 5 445.672 ± 49.516 ops/msJMHMain.weedInsert thrpt 5 217.909 ± 92.800 ops/msJMHMain.weedLambdaQuery thrpt 5 393.220 ± 31.256 ops/msJMHMain.weedPageQuery thrpt 5 241.266 ± 14.880 ops/msJMHMain.weedSelectById thrpt 5 414.971 ± 45.822 ops/msComplexMapping 表明繁杂投射,这儿是左连接一对多关联ExecuteJdbc是立即实行JDBC并将結果投射到POJOExecuteTemplate 是立即实行模版句子,并将結果投射到POJOFile,SQL句子储存在特有文档里Insert,内嵌增加句子One2Many 根据注释完成一对多查寻PageQuery 换页句子查寻,并回到一个PageResultSelectById 依据主键查寻POJOLambdaQuery 结构查寻的SQL句子,且适用重新构建基本功能介绍JMH性能测试程序BeetlSQL3 50 事例BeetlSQL3 适用多数据库完成基本原理 

猜你喜欢