if I not use batch-size then multiple select queries executes.e.g. if for 100 mgd_id, 100 select queries execute for Art class. If I use batch-size = 40 then I for 100 msg_id , 3 select query executes for Art class.
On console, what I found if you are not using batch-size the select query executes like select 1,2 from (table name)where id = ? where as if use batch size then select query will be like select 1,2 from (table name)where id in(?,?) where No.of ? is no. of batch size. can any body have idea that using batch-size how much improves performance or any side effect.