首页 \ 问答 \ MyBatis RowBounds与使用rownum和嵌套子查询的Oracle分页查询(MyBatis RowBounds vs Oracle pagination query using rownum and nested subquery)

MyBatis RowBounds与使用rownum和嵌套子查询的Oracle分页查询(MyBatis RowBounds vs Oracle pagination query using rownum and nested subquery)

 我想知道下面哪个在执行100k +记录的查询方面表现更好 
 

 1）Oracle的分页 
 

SELECT *
FROM  (
   SELECT id, col1, col2, rownum rn
   FROM (
      SELECT /*+ first_rows(50) */ id, col1, col2
      FROM   table1
      ORDER  BY id DESC
   )
   WHERE   rownum <= 50
)
WHERE  rn >= 20;

 

 2）使用MyBatis RowBounds进行分页 。 
 

 MyBatis RowBounds使用普通的JDBC，并在启动select后跳过前20条记录，然后获取下一个30（pagesize）。 
 

 另外，随着更多行需要跳过页码的增加，MyBatis方法会变慢吗？ 

I want to know which of the below performs better in terms of time to execute query with 100k+ records 
 

1) Oracle's Pagination 
 

SELECT *
FROM  (
   SELECT id, col1, col2, rownum rn
   FROM (
      SELECT /*+ first_rows(50) */ id, col1, col2
      FROM   table1
      ORDER  BY id DESC
   )
   WHERE   rownum <= 50
)
WHERE  rn >= 20;

 

2) Pagination using MyBatis RowBounds.
 

MyBatis RowBounds uses normal JDBC and after firing the select it skips the first 20 records and then fetches the next 30 (pagesize).
 

Also, will the MyBatis approach become slower as the page number increases as more rows needs to be skipped?

原文：https://stackoverflow.com/questions/11185705
更新时间：2022-05-26 08:05

最满意答案

 更改.strip1显示以display: table; 。 您可能还想更改.data以display: table-row; 。 将.data上的diaplay设置为table-row将允许您删除高度和宽度声明。 
 

 编辑：添加了片段 
 

 
 
 
  
body{
    padding:0;
}

.strip2 {
    background-color: #FFFFFF;
    height: 65%;
    position: absolute;
    top: 25%;
    left: 0;
    width: 100%;
    text-align: center;
}

.strip3 {
    background-color: green;
    height: 10%;
    position: absolute;
    bottom: 0px;
    left: 0;
    width: 100%;
}

.strip1 {
    background-color: red;
    height: 25%;
    position: absolute;
    top: 0px;
    left: 0;
    width: 100%;
    display:table;
}

.data {
    background-color: #00337C;
    display: table-row;
    height: 100%; /* you can remove height declaration if set to display:table-row */
    width: 100%; /* you can remove width declaration if set to display:table-row */     
}

.data_element {
   	color: #FFFFFF;
    font-size: 30px; 
    width: 100%;
    height: 100%;
    display: table-cell;
    vertical-align: middle;
    text-align: center;
    font-size: 30px;
}

.data_element.dataA {    
    width: 20%;    
}

.data_element.dataB {
    width: 50%;
}

.data_element.dataC {
    font-size: 20px;
}
 
  
<div class="container">
    <div class="strip1">
        <div class="data">
            <div class="data_element dataA">A</div>
            <div class="data_element dataB">B</div>
            <div class="data_element dataC">C</div>
        </div>
    </div>
    <div class="strip2"></div>
    <div class="strip3"></div>
</div>
 
 
 

 


Change .strip1 display to display: table;. You may also want to then change .data to display: table-row;. Setting the diaplay on .data to table-row will allow you to remove the height and width declarations.
 

Edited: Added snippet 
 

 
 
 
  
body{
    padding:0;
}

.strip2 {
    background-color: #FFFFFF;
    height: 65%;
    position: absolute;
    top: 25%;
    left: 0;
    width: 100%;
    text-align: center;
}

.strip3 {
    background-color: green;
    height: 10%;
    position: absolute;
    bottom: 0px;
    left: 0;
    width: 100%;
}

.strip1 {
    background-color: red;
    height: 25%;
    position: absolute;
    top: 0px;
    left: 0;
    width: 100%;
    display:table;
}

.data {
    background-color: #00337C;
    display: table-row;
    height: 100%; /* you can remove height declaration if set to display:table-row */
    width: 100%; /* you can remove width declaration if set to display:table-row */     
}

.data_element {
   	color: #FFFFFF;
    font-size: 30px; 
    width: 100%;
    height: 100%;
    display: table-cell;
    vertical-align: middle;
    text-align: center;
    font-size: 30px;
}

.data_element.dataA {    
    width: 20%;    
}

.data_element.dataB {
    width: 50%;
}

.data_element.dataC {
    font-size: 20px;
}
 
  
<div class="container">
    <div class="strip1">
        <div class="data">
            <div class="data_element dataA">A</div>
            <div class="data_element dataB">B</div>
            <div class="data_element dataC">C</div>
        </div>
    </div>
    <div class="strip2"></div>
    <div class="strip3"></div>
</div>

相关问答

更多

相关文章

更多
  • MyBatis XML 配置详解
  • MyBatis Java API详解
  • mybatis批量插入使用oracle序列做为主键出现"ORA-02287: 此处不允许序号"的解决方案
  • 源码解读Mybatis List列表In查询实现的注意事项
  • oracle
  • MyBatis 动态 SQL详解
  • 快速了解mybatis
  • 常用HQL(Hibernate Query Language)查询
  • solr学习笔记二-------solr query查询的参数
  • oracle查询问题

    • 最新问答

    更多
  • 获取MVC 4使用的DisplayMode后缀(Get the DisplayMode Suffix being used by MVC 4)
  • 如何通过引用返回对象？(How is returning an object by reference possible?)
  • 矩阵如何存储在内存中？(How are matrices stored in memory?)
  • 每个请求的Java新会话？(Java New Session For Each Request?)
  • css：浮动div中重叠的标题h1(css: overlapping headlines h1 in floated divs)
  • 无论图像如何，Caffe预测同一类(Caffe predicts same class regardless of image)
  • xcode语法颜色编码解释？(xcode syntax color coding explained?)
  • 在Access 2010 Runtime中使用Office 2000校对工具(Use Office 2000 proofing tools in Access 2010 Runtime)
  • 从单独的Web主机将图像传输到服务器上(Getting images onto server from separate web host)
  • 从旧版本复制文件并保留它们（旧/新版本）(Copy a file from old revision and keep both of them (old / new revision))
  • 西安哪有PLC可控制编程的培训
  • 在Entity Framework中选择基类(Select base class in Entity Framework)
  • 在Android中出现错误“数据集和渲染器应该不为null，并且应该具有相同数量的系列”(Error “Dataset and renderer should be not null and should have the same number of series” in Android)
  • 电脑二级VF有什么用
  • Datamapper Ruby如何添加Hook方法(Datamapper Ruby How to add Hook Method)
  • 金华英语角.
  • 手机软件如何制作
  • 用于Android webview中图像保存的上下文菜单(Context Menu for Image Saving in an Android webview)
  • 注意：未定义的偏移量：PHP(Notice: Undefined offset: PHP)
  • 如何读R中的大数据集[复制](How to read large dataset in R [duplicate])
  • Unity 5 Heighmap与地形宽度/地形长度的分辨率关系？(Unity 5 Heighmap Resolution relationship to terrain width / terrain length?)
  • 如何通知PipedOutputStream线程写入最后一个字节的PipedInputStream线程？(How to notify PipedInputStream thread that PipedOutputStream thread has written last byte?)
  • python的访问器方法有哪些
  • DeviceNetworkInformation：哪个是哪个？(DeviceNetworkInformation: Which is which?)
  • 在Ruby中对组合进行排序(Sorting a combination in Ruby)
  • 网站开发的流程？
  • 使用Zend Framework 2中的JOIN sql检索数据(Retrieve data using JOIN sql in Zend Framework 2)
  • 条带格式类型格式模式编号无法正常工作(Stripes format type format pattern number not working properly)
  • 透明度错误IE11(Transparency bug IE11)
  • linux的基本操作命令。。。

    • Copyright ©2023 peixunduo.com All Rights Reserved.粤ICP备14003112号

    本站部分内容来源于互联网，仅供学习和参考使用，请莫用于商业用途。如有侵犯你的版权，请联系我们(neng862121861#163.com)，本站将尽快处理。谢谢合作！