in reply to How to log SQL query execution in DBI

See the "TRACING" section of the DBI docs. You'll probably have to set up a redirected STDERR to make it log to a file.

After Compline,
Zaxo

  • Comment on Re: How to log SQL query execution in DBI

Replies are listed 'Best First'.
Re^2: How to log SQL query execution in DBI
by Fletch (Bishop) on Nov 28, 2005 at 16:29 UTC
    Trace Output Initially trace output is written to "STDERR". Both the "$h->t +race" and "DBI->trace" methods take an optional $trace_filename param +eter. If specified, and can be opened in append mode, then all trace out +put (currently including that from other handles) is redirected to +that file. A warning is generated if the file can't be opened.