TIMB / DBI_AdvancedTalk_200307 / sld064.htm 

<!--  Presentation generated by Internet Assistant for Microsoft PowerPoint 97 -->

<HTML>
<HEAD>

<meta name="GENERATOR" content="Microsoft Internet Assistant for Microsoft PowerPoint 97">
 <TITLE>Trace level 2 and above</TITLE> 
</HEAD>

<BODY     >

<CENTER>
<TABLE WIDTH=100%> 
     <TR> <TD WIDTH=100% ALIGN=CENTER>
         <A HREF="sld001.htm">First</A>&nbsp;&nbsp;
         <A HREF="sld063.htm">Previous</A>&nbsp;&nbsp;
         <A HREF="sld065.htm">Next</A>&nbsp;&nbsp;
         <A HREF="sld096.htm">Last</A>&nbsp;&nbsp;
&nbsp;&nbsp;         <A HREF="index.htm">Index</A>&nbsp;&nbsp;
         <A HREF="dbi.perl.org">Home</A>&nbsp;&nbsp;
         <A HREF="tsld064.htm">Text</A>&nbsp;&nbsp;
     </TD> </TR>
     <TR> <TD WIDTH=100% ALIGN=CENTER>
         <IMG SRC="img064.gif" usemap="#Objmap" WIDTH=800 HEIGHT=600 BORDER=0>
     </TD> </TR>
</TABLE>
<P>Slide 64 of 96</P>
</CENTER>
<!-- <UL>
<H2>Trace level 2 and above</H2>
</UL></P>
<P><UL>
<LI><H2>Level 2 adds trace of entry into methods, details of classes, handles, and more
</H2>
<UL>
<LI>we’ll just look at the trace for the prepare_cached() call here:
</UL></UL><UL>
<H2> 
</H2>
</UL><UL>
<H2>    -&#062 prepare_cached in DBD::_::db for DBD::mysql::db 				(DBI::db=HASH(0x8367568)~0x83674f0 'INSERT INTO prices ...')
</H2>
</UL><UL>
<H2>1   -&#062 FETCH for DBD::mysql::db (DBI::db=HASH(0x83674f0)~INNER 'CachedKids')
</H2>
</UL><UL>
<H2>1   &#060- FETCH= undef at DBI.pm line 1274
</H2>
</UL><UL>
<H2>1   -&#062 STORE for DBD::mysql::db (DBI::db=HASH(0x83674f0)~INNER 'CachedKids' 			HASH(0x8367790))
</H2>
</UL><UL>
<H2>1   &#060- STORE= 1 at DBI.pm line 1275
</H2>
</UL><UL>
<H2>1   -&#062 prepare for DBD::mysql::db (DBI::db=HASH(0x83674f0)~INNER
</H2>
</UL><UL>
<H2>			'INSERT INTO prices ...' undef)
</H2>
</UL><UL>
<H2>1   &#060- prepare= DBI::st=HASH(0x8367760) at DBI.pm line 1287
</H2>
</UL><UL>
<H2>    &#060- prepare_cached= DBI::st=HASH(0x8367760) at test.pl line 11
</H2>
</UL><UL>
<H2>
</H2>
</UL><UL>
<LI><H2>Trace level 3 and above shows more internal processing and driver details
</H2>
</UL><UL>
<LI><H2>Use $DBI::neat_maxlen to alter truncation of strings in trace output
</H2>
</UL><UL>
<H2>-
</H2>
</UL></P>
<P>  -->
</Body>
</HTML>