2 ** Performance test for SQLite.
4 ** This program reads ASCII text from a file named on the command-line.
5 ** It converts each SQL statement into UTF16 and submits it to SQLite
6 ** for evaluation. A new UTF16 database is created at the beginning of
7 ** the program. All statements are timed using the high-resolution timer
8 ** built into Intel-class processors.
10 ** To compile this program, first compile the SQLite library separately
11 ** will full optimizations. For example:
13 ** gcc -c -O6 -DSQLITE_THREADSAFE=0 sqlite3.c
15 ** Then link against this program. But to do optimize this program
16 ** because that defeats the hi-res timer.
18 ** gcc speedtest16.c sqlite3.o -ldl -I../src
20 ** Then run this program with a single argument which is the name of
21 ** a file containing SQL script that you want to test:
23 ** ./a.out database.db test.sql
33 ** hwtime.h contains inline assembler code for implementing
34 ** high-performance timing routines.
39 ** Convert a zero-terminated ASCII string into a zero-terminated
40 ** UTF-16le string. Memory to hold the returned string comes
41 ** from malloc() and should be freed by the caller.
43 static void *asciiToUtf16le(const char *z){
48 z16 = malloc( n*2 + 2 );
49 for(i=j=0; i<=n; i++){
59 static sqlite_uint64 prepTime = 0;
60 static sqlite_uint64 runTime = 0;
61 static sqlite_uint64 finalizeTime = 0;
64 ** Prepare and run a single statement of SQL.
66 static void prepareAndRun(sqlite3 *db, const char *zSql){
70 sqlite_uint64 iStart, iElapse;
73 printf("****************************************************************\n");
74 printf("SQL statement: [%s]\n", zSql);
75 utf16 = asciiToUtf16le(zSql);
76 iStart = sqlite3Hwtime();
77 rc = sqlite3_prepare16_v2(db, utf16, -1, &pStmt, &stmtTail);
78 iElapse = sqlite3Hwtime() - iStart;
80 printf("sqlite3_prepare16_v2() returns %d in %llu cycles\n", rc, iElapse);
83 iStart = sqlite3Hwtime();
84 while( (rc=sqlite3_step(pStmt))==SQLITE_ROW ){ nRow++; }
85 iElapse = sqlite3Hwtime() - iStart;
87 printf("sqlite3_step() returns %d after %d rows in %llu cycles\n",
89 iStart = sqlite3Hwtime();
90 rc = sqlite3_finalize(pStmt);
91 iElapse = sqlite3Hwtime() - iStart;
92 finalizeTime += iElapse;
93 printf("sqlite3_finalize() returns %d in %llu cycles\n", rc, iElapse);
98 int main(int argc, char **argv){
106 sqlite_uint64 iStart, iElapse;
107 sqlite_uint64 iSetup = 0;
112 fprintf(stderr, "Usage: %s FILENAME SQL-SCRIPT\n"
113 "Runs SQL-SCRIPT as UTF16 against a UTF16 database\n",
117 in = fopen(argv[2], "r");
118 fseek(in, 0L, SEEK_END);
120 zSql = malloc( nSql+1 );
121 fseek(in, 0L, SEEK_SET);
122 nSql = fread(zSql, 1, nSql, in);
125 printf("SQLite version: %d\n", sqlite3_libversion_number());
127 utf16 = asciiToUtf16le(argv[1]);
128 iStart = sqlite3Hwtime();
129 rc = sqlite3_open16(utf16, &db);
130 iElapse = sqlite3Hwtime() - iStart;
132 printf("sqlite3_open16() returns %d in %llu cycles\n", rc, iElapse);
134 for(i=j=0; j<nSql; j++){
139 isComplete = sqlite3_complete(&zSql[i]);
143 while( i<j && isspace(zSql[i]) ){ i++; }
147 prepareAndRun(db, &zSql[i]);
154 iStart = sqlite3Hwtime();
156 iElapse = sqlite3Hwtime() - iStart;
158 printf("sqlite3_close() returns in %llu cycles\n", iElapse);
160 printf("Statements run: %15d\n", nStmt);
161 printf("Bytes of SQL text: %15d\n", nByte);
162 printf("Total prepare time: %15llu cycles\n", prepTime);
163 printf("Total run time: %15llu cycles\n", runTime);
164 printf("Total finalize time: %15llu cycles\n", finalizeTime);
165 printf("Open/Close time: %15llu cycles\n", iSetup);
166 printf("Total Time: %15llu cycles\n",
167 prepTime + runTime + finalizeTime + iSetup);