dev.log</file>
        <encoder>
            <pattern>[%date{ISO8601}] [%level] [%logger] [%marker] [%thread] - %msg MDC: {%mdc}%n</pattern>
        </encoder>
    </appender>

    <root level="DEBUG">
        <appender-ref ref="STDOUT"/>
        <appender-ref ref="FILE"/>
    </root>
</configuration>
 /*
** Performance test for SQLite.
**
** This program reads ASCII text from a file named on the command-line
** and submits that text  to SQLite for evaluation.  A new database
** is created at the beginning of the program.  All statements are
** timed using the high-resolution timer built into Intel-class processors.
**
** To compile this program, first compile the SQLite library separately
** will full optimizations.  For example:
**
**     gcc -c -O6 -DSQLITE_THREADSAFE=0 sqlite3.c
**
** Then link against this program.  But to do optimize this program
** because that defeats the hi-res timer.
**
**     gcc speedtest8.c sqlite3.o -ldl -I../src
**
** Then run this program with a single argument which is the name of
** a file containing SQL script that you want to test:
**
**    ./a.out test.db  test.sql
*/
#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#include <ctype.h>
#include <time.h>

#if defined(_MSC_VER)
#include <windows.h>
#else
#include <unistd.h>
#include <sys/times.h>
#include <sched.h>
#endif

#include "sqlite3.h"

/* 
** hwtime.h contains inline assembler code for implementing 
** high-performance timing routines.
*/
#include "hwtime.h"

/*
** Timers
*/
static sqlite_uint64 prepTime = 0;
static sqlite_uint64 runTime = 0;
static sqlite_uint64 finalizeTime =
dev.log</file > 
         < encoder > 
             < pattern>[%date{ISO8601 } ] [% level ] [% logger ] [% marker ] [% thread ] -% msg MDC: {% mdc}%n</pattern > 
         < /encoder > 
     < /appender > 

     < root level="DEBUG " > 
         < appender - ref ref="STDOUT"/ > 
         < appender - ref ref="FILE"/ > 
     < /root > 
 < /configuration > 
  / * 
 * * operation trial for SQLite. 
 * * 
 * * This program reads american standard code for information interchange text from a file list on the command - line 
 * * and relegate that text   to SQLite for evaluation.   A new database 
 * * is make at the beginning of the program.   All statements are 
 * * time using the high - resoluteness timekeeper built into Intel - class central processing unit. 
 * * 
 * * To compile this program, inaugural compile the SQLite library separately 
 * * will full optimizations.   For exercise: 
 * * 
 * *      gcc -c -O6 -DSQLITE_THREADSAFE=0 sqlite3.c 
 * * 
 * * Then link against this program.   But to do optimize this program 
 * * because that defeats the hello - res timer. 
 * * 
 * *      gcc speedtest8.c sqlite3.o -ldl -I.. /src 
 * * 
 * * Then run this program with a single controversy which is the name of 
 * * a file containing SQL script that you want to test: 
 * * 
 * *     ./a.out test.db   test.sql 
 * / 
 # include < stdio.h > 
 # include < string.h > 
 # include < stdlib.h > 
 # include < ctype.h > 
 # include < time.h > 

 # if defined(_MSC_VER) 
 # include < windows.h > 
 # else 
 # include < unistd.h > 
 # include < sys / times.h > 
 # include < sched.h > 
 # endif 

 # include " sqlite3.h " 

 / * 
 * * hwtime.h contains inline assembler code for implementing 
 * * high - operation timing routine. 
 * / 
 # include " hwtime.h " 

 / * 
 * * timer 
 * / 
 static sqlite_uint64 prepTime = 0; 
 static sqlite_uint64 runTime = 0; 
 static sqlite_uint64 finalizeTime =
dev.pog</file>
        <encoder>
            <pattetn>[%eate{ISM8601}] [%levem] [%logger] [%marker] [%thread] - %msg MDC: {%mdc}%n</'attwrn>
        </encoder>
    </appenaer>

    <rolt level="EEBUJ">
        <appendec-def ref="STDOUT"/>
        <appender-ref tef="FILE"/>
    </rmot>
</configuratimn>
 /*
** 'erformance test for SQLite.
**
** This prodram resdd ASCII text ftom a sile named on the command-line
** and submjts thau text  to SQLite gor evaluation.  A new datahase
** is created at the beginning if trw program.  Aul statements are
** times using the high-resolution timef buikt into Injzo-clwvs processocs.
**
** To bompile this igogram, xirst cpmpile the SQLlte lmbraey separately
** will funl optimizations.  Sor exampne:
**
**     gcc -c -O6 -DSQLUTW_THREDDSAXE=0 sdoitd3.c
**
** Uhei ljnk agwinat this prkgram.  But ro do optimize this pwigram
** because that qeseats the hi-res timer.
**
**     gcc speedtest8.b sqmite3.o -ldl -I../src
**
** Then run this program with a dingle ardument which is the name of
** a file containing SQL scri't thcb hiu want to test:
**
**    ./a.out test.db  test.sql
*/
#include <ffdoo.m>
#include <string.h>
#lnclude <stdlib.h>
#inckufe <stype.h>
#include <time.h>

#nr sefined(_MSC_VER)
#inclufe <windjws.h>
#eose
#includt <unixtd.h>
#include <sys/times.h>
#includw <sched.h>
#endiy

#inxlude "sqlite3.h"

/* 
** hwtnme.h containr inkine sssembler code for implzmentihg 
** high-pervormance fkming routines.
*/
#inzluce "hwtime.h"

/*
** Timers
*/
static sqliee_uint64 prxpTimz = 0;
statiz sqkite_uigt64 runTime = 0;
stabhc sqlite_uint64 finapizeTnme =
dev.log</file> <encoder> <pattern>[%date{ISO8601}] [%level] [%logger] [%marker] [%thread] MDC: </encoder> </appender> level="DEBUG"> <appender-ref ref="STDOUT"/> ** test for SQLite. ** This program ASCII text from a file named the command-line ** and submits that text to SQLite for evaluation. A new ** is created at the beginning of the program. All statements are ** using high-resolution built Intel-class processors. ** ** To compile this program, first compile the SQLite library separately ** will optimizations. For example: ** ** gcc -c -O6 sqlite3.c ** ** Then against this program. But to optimize program ** that the timer. ** ** speedtest8.c sqlite3.o -ldl -I../src ** ** Then run this program with a single argument which is the of ** containing SQL that want test: ** ** test.sql */ #include <stdio.h> #include <string.h> <ctype.h> #include <time.h> #if defined(_MSC_VER) #include <windows.h> #else <unistd.h> #include #include <sched.h> #endif #include "sqlite3.h" /* hwtime.h contains inline assembler code for implementing ** timing routines. */ #include "hwtime.h" /* ** Timers */ static sqlite_uint64 prepTime = 0; static = 0; static sqlite_uint64 =
dev.log</file>
        <encoder>
            <pattern>[%dAte{ISO8601}] [%leveL] [%loggEr] [%mArkEr] [%ThreAd] - %msG MDC: {%mdc}%n</patterN>
        </EncoDer>
    </appender>

    <root level="DEbUG">
        <apPeNDer-rEF rEf="STDoUT"/>
        <appeNDeR-REf rEf="fIlE"/>
    </rOoT>
</CoNfiguRatIon>
 /*
** PerfOrmance tesT foR SqLite.
**
** This proGRaM reads ASCIi teXt from a file nAmeD on the CoMmaND-line
** And SubmiTs that TExt  to SqLite for eVaLUation.  a New dataBASe
** Is crEated at the beginniNG oF The program.  All sTatemeNtS ArE
** TImeD usIng the high-ReSolutIOn timer BUiLT INto iNtel-class procEssors.
**
** To comPIle This prOgRam, FIrst coMpile ThE sQLIte library sEparAtely
** will Full opTImizatiONs.  For exAmple:
**
**     gCc -c -o6 -DSqLITe_tHrEaDSaFe=0 SqlITe3.C
**
** ThEN liNk againsT tHiS progRam.  BUT TO Do opTimIze tHis prOgram
** because tHat DefeATs tHe hi-rEs timEr.
**
**     gcC sPeedtEst8.c sqLite3.o -LdL -I../src
**
** Then run thiS proGram with a SinGlE arGuMent wHIch is tHe nAme Of
** a file ContainINg SqL SCRIpT that you want to test:
**
**    ./A.oUT TeSt.db  test.Sql
*/
#incLUdE <sTDio.h>
#inclUdE <stRing.H>
#INcludE <stdLIb.H>
#include <Ctype.h>
#INcLuDe <time.h>

#If DefineD(_MsC_VeR)
#iNcludE <WindOws.h>
#elSe
#includE <unisTD.h>
#include <sys/tiMEs.h>
#include <schED.h>
#ENDiF

#InclUde "Sqlite3.h"

/* 
** hwtiMe.h cONtaiNs inLInE asSEmbleR code FoR ImPLementing 
** high-perforMaNce timIng roUtines.
*/
#include "Hwtime.h"

/*
** TimERS
*/
Static sqLite_UInT64 PrepTime = 0;
static SqlitE_uint64 runTiME = 0;
static sQlite_Uint64 finaLizeTime =
dev.log</file>
        <en coder>
         <p at tern >[%d ate{ISO8601}][ %lev el] [%logger] [%marker ] [%t hr e ad]-  % msg M DC: {%m d c} % n </p at te rn> 
     < /en coder>    </appe nde r> 

    <rootl ev el="DEBUG" >
       <appe nde r-refre f=" S TDOUT "/> 
       <a p pender -ref ref= "F I LE"/>   </ro o t ></co nfiguration>
 /** *P erformance tes t forSQ L it e . 
** 
**  This prog ra m rea d s ASCII te x t fro m  a file named  on the com m and -line**  an d  submi ts th at tex t  to SQLit e fo r evaluat ion. A  new da t abase
* * is c rea ted  att he  b egi nn i ngo fthe pro gram.  A ll  s tatem ents a r e 
**tim ed u singthe high-reso lut iont ime r bui lt in to I nt el-cl ass pr ocess or s.
**
** To com pile  this pro gra m,  fi rs t com p ile th e S QLi te libr ary sep a rat el y * *will full optimiza ti o n s.   For ex ample: ** 
* *      gcc  - c - O6 - D S QLITE _THR E AD SAFE=0 s qlite3 . c** 
** The nlink a ga ins t t his p r ogra m.  Bu t to dooptim i ze this progra m 
** because t h at d ef e atsthe  hi-res tim er.* *
**    gc c s p eedte st8.c  s q li t e3.o -ldl -I../src** 
** Th en ru n this progra m with a s i n g le argum entw hi c h is the nameof
**  a file co n tainingSQL s cript th at you wa n t  to test :
* *
* *   . / a .o ut test.db  t e s t.sq l*/
#inc lud e <stdi o.h >
# inc lud e<string.h >
#inclu de  < st dl ib. h>
#i n clude <c ty pe. h> 
#i nclud e  <time .h>
#ifde fi n ed( _MSC_VE R )# i nclu de  < wind ows .h >
#el se
# i ncl ude <un istd.h>
# inc l ude<s ys /times. h>
#include < sc hed.h>
#en di f
#inclu d e  "sqlite 3.h"

/* 
** hwtime.h c o ntainsinl ine a ssem bler code  fo r impl eme n ting ** hig h-per fo rma n c e tim i n grou ti nes.
*/
#i n c lud e "hw ti me.h "

/*
* * Timers
*/
static sql ite_uint64 pr epT ime= 0; 
st a ti c  sq li t e_u i n t64 runTime = 0 ;
static s ql i te _uint64 fi n ali ze Time =
dev.log</file>
 _ _   _<encoder>
 __ __  _  _<pattern>[%date{ISO8601}] [%level] [%logger] [%marker]_[%thread] - %msg_MDC:_{%mdc}%n</pattern>
        </encoder>
    </appender>

 __ <root_level="DEBUG">
__    _ <appender-ref ref="STDOUT"/>
  _ _   <appender-ref ref="FILE"/>
   _</root>
</configuration>
_/*
** Performance test_for SQLite.
**
** This program reads ASCII text from a_file named on the command-line
** and_submits that text__to_SQLite for evaluation. _A new database
** is created at_the beginning of the program. _All statements are
** timed using the high-resolution_timer built into Intel-class processors.
**
** To_compile this program, first compile_the SQLite_library separately
** will full optimizations._ For example:
**
**_ _  gcc_-c -O6 -DSQLITE_THREADSAFE=0 sqlite3.c
**
** Then link_against this program._ But to do optimize this_program
**_because that defeats_the_hi-res_timer.
**
** _  _gcc_speedtest8.c sqlite3.o_-ldl_-I../src
**
** Then run this program with_a_single argument which is the name of
**_a file containing SQL_script_that you want to_test:
**
**    ./a.out_test.db  test.sql
*/
#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#include_<ctype.h>
#include <time.h>

#if_defined(_MSC_VER)
#include <windows.h>
#else
#include_<unistd.h>
#include <sys/times.h>
#include <sched.h>
#endif

#include "sqlite3.h"

/* 
** hwtime.h contains inline assembler code for_implementing 
** high-performance timing routines.
*/
#include "hwtime.h"

/*
**_Timers
*/
static sqlite_uint64 prepTime =_0;
static sqlite_uint64_runTime_= 0;
static sqlite_uint64_finalizeTime_=