<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    隨筆 - 175  文章 - 202  trackbacks - 0
    <2012年6月>
    272829303112
    3456789
    10111213141516
    17181920212223
    24252627282930
    1234567

    第一個Blog,記錄哈哈的生活

    常用鏈接

    留言簿(16)

    隨筆分類

    隨筆檔案

    文章分類

    文章檔案

    收藏夾

    Java links

    搜索

    •  

    最新評論

    閱讀排行榜

    評論排行榜

    http://dev.mysql.com/doc/refman/5.5/en/connector-j-reference-implementation-notes.html @import url(http://m.tkk7.com/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css);


    ResultSet

    By default, ResultSets are completely retrieved and stored in memory. In most cases this is the most efficient way to operate, and due to the design of the MySQL network protocol is easier to implement. If you are working with ResultSets that have a large number of rows or large values, and cannot allocate heap space in your JVM for the memory required, you can tell the driver to stream the results back one row at a time.

    To enable this functionality, create a Statement instance in the following manner:

    stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
    java.sql.ResultSet.CONCUR_READ_ONLY);
    stmt.setFetchSize(Integer.MIN_VALUE);

    The combination of a forward-only, read-only result set, with a fetch size of Integer.MIN_VALUE serves as a signal to the driver to stream result sets row-by-row. After this, any result sets created with the statement will be retrieved row-by-row.

    There are some caveats with this approach. You must read all of the rows in the result set (or close it) before you can issue any other queries on the connection, or an exception will be thrown.

    The earliest the locks these statements hold can be released (whether they be MyISAM table-level locks or row-level locks in some other storage engine such as InnoDB) is when the statement completes.

    If the statement is within scope of a transaction, then locks are released when the transaction completes (which implies that the statement needs to complete first). As with most other databases, statements are not complete until all the results pending on the statement are read or the active result set for the statement is closed.

    Therefore, if using streaming results, process them as quickly as possible if you want to maintain concurrent access to the tables referenced by the statement producing the result set.

    posted on 2012-06-29 13:15 哈哈的日子 閱讀(475) 評論(0)  編輯  收藏

    只有注冊用戶登錄后才能發表評論。


    網站導航:
     
    主站蜘蛛池模板: 久久亚洲高清观看| 亚洲Av永久无码精品三区在线| 亚洲国产日韩在线一区| 无码专区AAAAAA免费视频| 久久亚洲国产精品五月天婷| 曰批免费视频播放在线看片二 | 亚洲综合久久一本伊伊区| 国产人成免费视频网站| 亚洲国产精品yw在线观看| 无码日韩精品一区二区免费| 亚洲精品午夜国产va久久| 最近2019中文字幕免费看最新| 免费毛片毛片网址| 国产在线观看www鲁啊鲁免费| 久久精品国产亚洲av品善| 亚洲Av无码国产情品久久| 国产一级在线免费观看| 亚洲AV无码久久寂寞少妇| 国产h视频在线观看网站免费| 99久久婷婷国产综合亚洲| 国产成人免费手机在线观看视频 | 午夜亚洲av永久无码精品| 男人扒开添女人下部免费视频| 国产午夜亚洲精品午夜鲁丝片| 精品免费tv久久久久久久| 亚洲国产精品张柏芝在线观看| 免费观看男人免费桶女人视频| 香蕉视频亚洲一级| 亚洲人成77777在线播放网站| 免费无码又爽又刺激高潮视频| 国产.亚洲.欧洲在线| 亚洲 自拍 另类小说综合图区| 色www永久免费| 亚洲粉嫩美白在线| 亚洲国产日韩在线观频| 97在线视频免费播放| 日本亚洲高清乱码中文在线观看 | 中文字幕亚洲第一| 噼里啪啦免费观看高清动漫4| 水蜜桃视频在线观看免费| 日木av无码专区亚洲av毛片|