>Btw, it returned:
>
>select * from parcel where joborderid=?joborder.id
>
>which was what is in the class really.
>
>May I say again that this worked for a few thousand, but took longer (hours) as the record count grew, and eventually freezed.
>
>Thanks
>Dennis

Did you also check SelectCmd ? In addition, could MySQL also suffer from parameter sniffing problem (doubtfully). Try (for now) to embed the ID into the selectCmd explicitly.