third_party/sqlite/src/tool/speedtest16.c

   1 /*
   2 ** Performance test for SQLite.
   3 **
   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.
   9 **
  10 ** To compile this program, first compile the SQLite library separately
  11 ** will full optimizations.  For example:
  12 **
  13 **     gcc -c -O6 -DSQLITE_THREADSAFE=0 sqlite3.c
  14 **
  15 ** Then link against this program.  But to do optimize this program
  16 ** because that defeats the hi-res timer.
  17 **
  18 **     gcc speedtest16.c sqlite3.o -ldl -I../src
  19 **
  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:
  22 **
  23 **     ./a.out database.db test.sql
  24 */
  25 #include <stdio.h>
  26 #include <string.h>
  27 #include <stdlib.h>
  28 #include <ctype.h>
  29 #include <unistd.h>
  30 #include "sqlite3.h"
  31
  32 /*
  33 ** hwtime.h contains inline assembler code for implementing
  34 ** high-performance timing routines.
  35 */
  36 #include "hwtime.h"
  37
  38 /*
  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.
  42 */
  43 static void *asciiToUtf16le(const char *z){
  44   int n = strlen(z);
  45   char *z16;
  46   int i, j;
  47
  48   z16 = malloc( n*2 + 2 );
  49   for(i=j=0; i<=n; i++){
  50     z16[j++] = z[i];
  51     z16[j++] = 0;
  52   }
  53   return (void*)z16;
  54 }
  55
  56 /*
  57 ** Timers
  58 */
  59 static sqlite_uint64 prepTime = 0;
  60 static sqlite_uint64 runTime = 0;
  61 static sqlite_uint64 finalizeTime = 0;
  62
  63 /*
  64 ** Prepare and run a single statement of SQL.
  65 */
  66 static void prepareAndRun(sqlite3 *db, const char *zSql){
  67   void *utf16;
  68   sqlite3_stmt *pStmt;
  69   const void *stmtTail;
  70   sqlite_uint64 iStart, iElapse;
  71   int rc;
  72
  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;
  79   prepTime += iElapse;
  80   printf("sqlite3_prepare16_v2() returns %d in %llu cycles\n", rc, iElapse);
  81   if( rc==SQLITE_OK ){
  82     int nRow = 0;
  83     iStart = sqlite3Hwtime();
  84     while( (rc=sqlite3_step(pStmt))==SQLITE_ROW ){ nRow++; }
  85     iElapse = sqlite3Hwtime() - iStart;
  86     runTime += iElapse;
  87     printf("sqlite3_step() returns %d after %d rows in %llu cycles\n",
  88            rc, nRow, iElapse);
  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);
  94   }
  95   free(utf16);
  96 }
  97
  98 int main(int argc, char **argv){
  99   void *utf16;
 100   sqlite3 *db;
 101   int rc;
 102   int nSql;
 103   char *zSql;
 104   int i, j;
 105   FILE *in;
 106   sqlite_uint64 iStart, iElapse;
 107   sqlite_uint64 iSetup = 0;
 108   int nStmt = 0;
 109   int nByte = 0;
 110
 111   if( argc!=3 ){
 112     fprintf(stderr, "Usage: %s FILENAME SQL-SCRIPT\n"
 113                     "Runs SQL-SCRIPT as UTF16 against a UTF16 database\n",
 114                     argv[0]);
 115     exit(1);
 116   }
 117   in = fopen(argv[2], "r");
 118   fseek(in, 0L, SEEK_END);
 119   nSql = ftell(in);
 120   zSql = malloc( nSql+1 );
 121   fseek(in, 0L, SEEK_SET);
 122   nSql = fread(zSql, 1, nSql, in);
 123   zSql[nSql] = 0;
 124
 125   printf("SQLite version: %d\n", sqlite3_libversion_number());
 126   unlink(argv[1]);
 127   utf16 = asciiToUtf16le(argv[1]);
 128   iStart = sqlite3Hwtime();
 129   rc = sqlite3_open16(utf16, &db);
 130   iElapse = sqlite3Hwtime() - iStart;
 131   iSetup = iElapse;
 132   printf("sqlite3_open16() returns %d in %llu cycles\n", rc, iElapse);
 133   free(utf16);
 134   for(i=j=0; j<nSql; j++){
 135     if( zSql[j]==';' ){
 136       int isComplete;
 137       char c = zSql[j+1];
 138       zSql[j+1] = 0;
 139       isComplete = sqlite3_complete(&zSql[i]);
 140       zSql[j+1] = c;
 141       if( isComplete ){
 142         zSql[j] = 0;
 143         while( i<j && isspace(zSql[i]) ){ i++; }
 144         if( i<j ){
 145           nStmt++;
 146           nByte += j-i;
 147           prepareAndRun(db, &zSql[i]);
 148         }
 149         zSql[j] = ';';
 150         i = j+1;
 151       }
 152     }
 153   }
 154   iStart = sqlite3Hwtime();
 155   sqlite3_close(db);
 156   iElapse = sqlite3Hwtime() - iStart;
 157   iSetup += iElapse;
 158   printf("sqlite3_close() returns in %llu cycles\n", iElapse);
 159   printf("\n");
 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);
 168   return 0;
 169 }