Re: [hibernate-dev] batch-size algorithm

2006-09-28 Thread Max Rydahl Andersen
sounds reasonable IFF the db doesn't get stupid and does 20 lookups for duplicate id's. /max Currently we create several loaders following a certain algorithm Why don't we create a single loader of batch-size and duplicate ids in the in clause to match unfilled parameters batch-size = 2

[hibernate-dev] batch-size algorithm

2006-09-26 Thread Emmanuel Bernard
Currently we create several loaders following a certain algorithm Why don't we create a single loader of batch-size and duplicate ids in the in clause to match unfilled parameters batch-size = 20 uninitialized proxies 17 current algorithm select * from Table where id in (1, 2, 3, 4, 5, 6, 7, 8