while (my $rows = $sth->fetchall_arrayref( [@slice], $maxrows)) {
    last unless @$rows;
    
    # do stuff

    last if @$rows < $maxrows;
}

die $sth->errstr if $sth->errstr;