> Yes, I know. And I might end up doing this in the end. I do though have > pretty hard upper limits of how many rows I will end up with for each key, > but anyways it might be a good idea none the less. Thanks for the advice on > that one.
You set count to Integer.MAX. Did you try with say 30000? IIRC that makes a difference (while it shouldn't) even when you have still less than 30000. Paging is the way to go. cheers -- Torsten