• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

performance using batch-size in set

 
Rajan Nath
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
entries in my hbm.xml like that



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.

Thanks,
Raj
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic