一个list中有很50W的uuid，如何根据uuid在100W的数据库中快速匹配出这50Wuuid对应的数据并返回

Question

select DISTINCT

            t.CATARC_CODE AS catarcCode,

            t.CCS5 AS ccs5,

            t.VEC_MOD AS vecMod,

            t.VEC_NAME AS vecName,

            t.AUTO_PRICE AS autoPrice,

            f.CLXH AS clxh,

            a.AUTOMARKER_NAME AS automarkerInfo,

            t.DRIVE_WAY AS driveWay,

            t.MODEL_YEAR AS modelYear,

            t.VEC_CONFIG_DETAIL AS vecConfigDetail,

            t.EXTEND_INFO AS extendInfo,

            f.CLZZRQ AS vinTime,

            t.ENGINE_MOD AS engineMod,

            f.RLZL AS oilWay,

            t.VEC_MOD_TYPE AS vecModType,

            t.BODY_STRUCT AS bodyStruct,

            f.FDJXH AS fdjxh,

            f.FDJH AS fdjh,

            f.LTGG AS ltgg,

            t.AUTOMARKER_ID AS automakerId,

            f.CSYS AS csys,

            f.PFBZ AS pfbz,

            f.EDZK AS edzk,

            f.WKC AS wkc,

            f.WKK AS wkk,

            f.WKG AS wkg,

            f.ZJ AS zj,

            f.PL_L AS plL,

            f.QLJ AS qlj,

            f.HLJ AS hlj,

            f.ZZL AS zzl,

            f.ZBZL AS zbzl,

            f.GL AS gl,

            f.YH AS yh,

            f.LTS AS lts,

            f.ZH AS zh,

            f.ZS AS zs,

            f.SYXZ AS syxz

  from T_PVEC_STD t,
  (select
    t.CATARC_CODE,
    t.CLXH,
    t.VIN,
    t.clzzrq,
    d.FDJXH,
    d.FDJH,
    d.LTGG,
    d.RLZL,
    d.CSYS,
    d.PFBZ,
    d.EDZK,
    d.WKC,
    d.WKK,
    d.WKG,
    d.ZJ,
    d.PL_L,
    d.QLJ,
    d.HLJ,
    d.ZZL,
    d.ZBZL,
    d.GL,
    d.YH,
    d.LTS,
    d.ZH,
    d.ZS,
    d.SYXZ
    from T_VIN_INFO t left join T_VIN_FDJ d on d.vin = t.vin) f,
  T_AUTOMAKER_INFO a
  where f.CATARC_CODE = t.CATARC_CODE
  and t.AUTOMARKER_ID = a.AUTOMARKER_ID and  f.vin = #{analysisExcelVO.vinCode}

Answer 1

uuid不是主键的话建立索引。然后list分割大小一万。循环查数据库select * from table where uuid in (1,2,3);
另外，你这50万条业务数据一定不能放在一个list中（内存溢出风险，不提倡），应该每一万条业务处理一次。