Steve Baldwin schrieb am 23.04.2012 um 20:53 (+1000): > > loop > select count(*) from some_table > sleep 2 seconds > end loop > > My problem is that the count shows the number of rows the first time > it executes and from that point never changes. > > While the program is running, I insert rows into the table from > another session but the count never changes. If I kill the program > and restart it, it shows the new count but again never changes.
Try setting AutoCommit => 1 to run each statement in its own transaction. This should be the default, though. https://metacpan.org/module/DBI#AutoCommit Michael
