[Dbix-class] SQL trace

Rob Kinyon rob.kinyon at gmail.com
Thu Nov 10 20:25:42 GMT 2011


On Thu, Nov 10, 2011 at 14:52, Charlie Katz <ckatz at cfa.harvard.edu> wrote:
> Hi,
> With SQL tracing turned on via $schema->storage->debug(1), does every SQL
> statement reported represent a trip to the database?  Or is it showing the
> SQL that would be required to retrieve the requested value, regardless of
> whether it's already in memory?

It is the actual SQL that was sent to the DB. Anything that DBIC can
find without going to the DB doesn't generate SQL, let alone get shown
in the trace.

Rob



More information about the DBIx-Class mailing list