--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Symbian3/SDK/Source/GUID-EC33FF66-F15E-5316-8828-C6CFD57DB9E5.dita	Wed Mar 31 11:11:55 2010 +0100
@@ -0,0 +1,57 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. -->
+<!-- This component and the accompanying materials are made available under the terms of the License 
+"Eclipse Public License v1.0" which accompanies this distribution, 
+and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". -->
+<!-- Initial Contributors:
+    Nokia Corporation - initial contribution.
+Contributors: 
+-->
+<!DOCTYPE concept
+  PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd">
+<concept id="GUID-EC33FF66-F15E-5316-8828-C6CFD57DB9E5" xml:lang="en"><title>Symbian
+SQL Tracing Guide</title><shortdesc>This document discusses how to enable Symbian SQL tracing</shortdesc><prolog><metadata><keywords/></metadata></prolog><conbody>
+<section id="GUID-8DC1D32E-F2AB-48C5-9BF9-4D7D49865FD5"><title>How to enable
+Symbian SQL tracing</title> <p>You can enable SQL tracing in two steps. </p> <ul>
+<li id="GUID-1AB89A3E-6ACD-543D-8AA9-B9034829E947"><p>Enable the executable
+for trace. </p> </li>
+<li id="GUID-DF51C397-6531-5CAF-A087-257E2FB06E8E"><p>Enable the trace type. </p> </li>
+</ul> <p><b>Enabling
+the executable for trace</b> </p> <p>The three sub-components of the Symbian
+SQL library executable are the database client, the database server and the
+SQLite static library with these .mmp files: </p> <ul>
+<li id="GUID-A2B6B7EF-509F-52C7-A55C-20CAE7766995"><p>sqldb.mmp </p> </li>
+<li id="GUID-2973082E-45F0-5829-B0E3-EA39BA8B0F06"><p>sqlsrv.mmp </p> </li>
+<li id="GUID-20750D91-BA05-5623-9E54-E02BBFDE1EE4"><p>sqlite.mmp </p> </li>
+</ul> <p>In each of these files look for the macro <codeph>SYMBIAN_INCLUDE_EXECUTABLE_TRACE</codeph> and
+uncomment it. </p> <p><b>Enabling
+the trace type</b> </p> <p>SQL traces are of three types: </p> <ul>
+<li id="GUID-2F30AEB6-0C62-52F6-958F-892A5C0DDEA5"><p>Function entry and exit
+traces: these traces generate timestamps indicating how long a function took
+to execute and what its argument was. Where the argument is an SQL statement,
+these traces are useful for identifying inefficient use of SQL. </p> </li>
+<li id="GUID-7D1B8AF5-F525-5A4A-9C2C-465752DC73D8"><p>Error traces: these
+trace function leaves and panics in the client and server and are useful for
+debugging database applications. </p> </li>
+<li id="GUID-1271AC2F-FEBA-579E-B990-B0EE1272B17C"><p>Key event traces: these
+traces supply data about key events which are relevant to database implementation: </p> <ul>
+<li id="GUID-E2CB61F2-5F38-54AE-B27D-A4FBC5BE1D36"><p>IPC calls sent to and
+serviced by the SQL server. </p> </li>
+<li id="GUID-45B84E0B-429D-5FCA-8144-DF807EC99545"><p>Startup and close of
+the SQL server. </p> </li>
+<li id="GUID-89FE8F63-FDE0-5D99-B8EA-21895FBDA866"><p>The number of full table
+scans and sort operations performed by an <xref href="GUID-0176BF07-DF94-3259-8F90-DE030E35CE9A.dita"><apiname>RSqlStatement</apiname></xref> object. </p> </li>
+</ul> </li>
+</ul> <p>Traces of each type can be enabled independently. The file UTraceSql.h
+defines the macros </p> <ul>
+<li id="GUID-A208CA4B-DB3C-5C02-A356-CBF4560E81A5"><p> <codeph>SYMBIAN_TRACE_SQL_FUNC</codeph> to
+enable function entry and exit traces, </p> </li>
+<li id="GUID-4B10F95F-6A9D-5F28-8213-C006C6220A91"><p> <codeph> SYMBIAN_TRACE_SQL_ERR</codeph> to
+enable error traces, and </p> </li>
+<li id="GUID-520483F9-698B-55DF-9D47-1AB969D2ECAC"><p> <codeph>SYMBIAN_TRACE_SQL_EVENTS</codeph> to
+enable key events. </p> </li>
+</ul> <p>To enable tracing you uncomment the macro for the type of tracing
+required. </p> </section>
+<section id="GUID-04A105B3-DEC2-4E6C-9463-81357E5AFD08"><title>See Also</title> <p><xref href="GUID-321F406B-2C77-5F2B-9FDA-F25726188CE2.dita">Using Symbian SQL Trace Data
+Guide</xref>  </p> </section>
+</conbody></concept>
\ No newline at end of file