Thanks to Bill Moseley who wrote:
I think the first line that I have left above was the secret in the sauce. It made all the difference. Thanks Bill (and Mike)[snip] my @ids = map { $_->Property( 'id' ) } @swish_results; [snip] my $recs = $sth->fetchall_hashref('id'); my @results = map { $recs->{$_} } @ids;
Walter