select *
from t_data_info where
<foreach collection="infoDtos" index="index" item="info" separator="or">
1=1
<if test="info.a!=null and info.a!=''">
and a like #{info.a}
</if>
<if test="info.b!=null and info.b!=''">
and b like #{info.b}
</if>
<if test="info.c!=null and info.c!=''">
and c like #{info.c}
</if>
</foreach>
类似这种形式的查询,JAVA后台传过来的infoDtos是几千个对象组成的list,会不会影响数据库本身性能?