in reply to Re^4: rows affected by an update command
in thread rows affected by an update command

To be pedantic, "no, it won't", but I understand what you say. DBI tracing might show only what DBI executes, but depending on the DBD, it might also show you exactly what teh database is doing. There are just a few guidelines for debug support in DBD's, and while we are very slowly trying to get those in line, the way the DBD interprets the trace settings is still very depending on how the author of the DBD thinks that is done best.

In DBD::Unify I started to support the dbd_verbose attribute a long long time ago, and it is now also supported in DBD::Oracle and DBD::Pg and perhaps in others too by now.

The advantage of using dbd_verbose is that you by now probably trust that DBI does what it is supposed to do (bug-free). Most of the time, the problems encountered are not in the DBI interface, but on the DBD side, and dbd_verbose will control what the DBD is printing as debug information while DBI will completely ignore it.

It however still holds that depending on the DBD, this information might be differing from what the database engine/server actually executes, but at least you're getting information that is closer to the truth than what the top level knows about.

Hope this helps a bit ...


Enjoy, Have FUN! H.Merijn