Subject says most - I found that when I do replicate(), hibernate is executing single queries against the database:
select ID from TABLE where ID = $1

this is the exact query. This wouldn't be a problem except there is like 30k of these queries to perform. I have batch-size turned on at both class and bag/set levels, and nada.

Am I seeing a bug?

Thanks,
-ryan

Isnt batch size just involved in insert and update ?
Just wondering.

the documentation states that batch-size is used when doing selects - this is most often used when you are doing either child-gets or doing lots of loads that can be lazy loaded. Hibernate can then batch up all the selects.

It seems hibernate is testing to see which children already exist - which is good, but the problem for me is that there are like 45,000 children. So that makes for 45,000 queries - the database IPC overhead is killing me :-)