I also think this would not address the delay between deleting and selecting.

I wonder how one does table/record locking with industrial strength databases like SQL Server or Oracle using Perl and DBI. I really didn't find anything in the DBI documentation that addresses locking issues.