in reply to DBI trace has limited output

The DBI documentation says that SQL statement tracing is not implemented in DBI, but in some DBDs. That might be one line of investigation. If your database driver does not support SQL tracing you are out of luck.

Another line of investigation is whether you are enabling trace correctly. I have not used CGI in a long time, and may not be of help, but I suspect that to get help on that you will need to say how you are trying to enable tracing.

Replies are listed 'Best First'.
Re^2: DBI trace has limited output
by Anonymous Monk on Oct 23, 2021 at 17:38 UTC
    I use DBI->trace( 99, 'my_program.trace' ); and it's other variations.I know that the dbd driver works because in other environments(non CGI) I get the desired outcome.