[GitHub] [shardingsphere] lishijun121910 commented on issue #6676: sharding-jdbc sharding performance

[GitBox <gi...@apache.org>]

lishijun121910 commented on issue #6676:
URL: https://github.com/apache/shardingsphere/issues/6676#issuecomment-670310706


   > @lishijun121910 Thanks for your test report. Let's give it a discussion.
   > 
   > 1. Could you provide these test SQLs?
   > 2. What's the difference between the second one and the third one?
   > 3. Which tool did you use for testing?
   
   1. sql is 
       select
       <include refid="Base_Column_List" />
       from T_MERCHANT
       where INST_ID = #{inst_id,jdbcType=DECIMAL}
       and MCC_ID = #{mcc_id,jdbcType=DECIMAL}
       and MCHNT_ID = #{mchnt_id,jdbcType=VARCHAR}
   
   2. the second is sharding-jdbc with 1 table(30000000rows), the third is sharding-jdbc with 64 table(1 into 64, 500000 rows).
    
   3. I am using springboot+shardingjdbc+mybatis application for testing.
   
   
   Our team discussed about the testing result today,  it is reasonable and as expected.
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org