note tokpela <p> Two things I see (not sure if this will solve your issue): </p> <p> <code> my $update_ids = $dbh->prepare("UPDATE queue set processed = \'T\' where id = $ids"); </code> </p> <p> You are preparing the update statement on every while loop iteration. I think you should prepare the update statement before the while loop and use a placeholder for your id value. </p> <p> <code> my $update_ids = $dbh->prepare("UPDATE queue set processed = 'T' where id = ?"); </code> </p> <p> Also, what is the \'T\' for? 'T' should work fine since you are quoting the SQL with double quotes and don't need to escape the single quote. </p> 905524 905524