Re: Placeholders for profiling?
[email protected] (Chris Nehren)
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <[email protected]> |
On Tue, Feb 09, 2010 at 22:58:06 -0000 , Greg Sabino Mullane wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
>
>
> > We've got a situation where we need to get the placeholders
> > used for statements when doing profiling. I've RTFM'd and RTFS'd
> > and not found any leads. What do I need to poke to get this
> > information?
>
> I'm not terribly familiar with DBI::Profile, but looking at the
> code, the main bits are in DBI's DBI.xs, and the execute section of
> dbi_profile only looks at $h->{Statement}, not $h->{ParamValues},
> so I don't think the information is available.
>
> Thus, your options are probably to call $h->{ParamValues} yourself,
> or increase the DBI logging to have it show the execute values.
> Looks like a trace level of 1 should be sufficient for the latter.
Aha. Thank you for the detailed response. I'll see if I can't make this
do what I need.
--
Thanks and best regards,
Chris Nehren