Originally posted by Andreas Ecker:
just curiousity: why is it good to use batch sizes, that are relativley prime?
Why will this give you less server roundtrips?
Originally posted by Amy Smith:
Great algorithm, thanks.
If you have the luxury of knowing values that are out of range for the column in the where, use the out of range values for the extra parameter values. This would let you handle the stragglers in one query.
IE. selecting by an id column that is always a positive number.
select ... from ... where ... in (?,?,?,?,?) and you are looking for "1,2,3". Use -1 for the other 2 parameters.
Originally posted by Pradip Bhat:
Is the above a typo ? The method signature should have a parameter index followed by the integer value.
Originally posted by Dan Geck:
so yeah it's not applicable for PreparedStatement.
There were millions of the little blood suckers. But thanks to this tiny ad, I wasn't bitten once.
Two software engineers solve most of the world's problems in one K&R sized bookhttps://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton