third_party/sqlite/sqlite-src-3100200/tool/speedtest16.c - Issue 2846743003: [sql] Remove SQLite 3.10.2 reference directory.

Side by Side Diff: third_party/sqlite/sqlite-src-3100200/tool/speedtest16.c

Issue 2846743003: [sql] Remove SQLite 3.10.2 reference directory. (Closed)

Patch Set: Created 3 years, 7 months ago

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Jump to:

OLD	NEW
	(Empty)
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 #define ISSPACE(X) isspace((unsigned char)(X))

33

34 /*

35 ** hwtime.h contains inline assembler code for implementing

36 ** high-performance timing routines.

37 */

38 #include "hwtime.h"

39

40 /*

41 ** Convert a zero-terminated ASCII string into a zero-terminated

42 ** UTF-16le string. Memory to hold the returned string comes

43 ** from malloc() and should be freed by the caller.

44 */

45 static void asciiToUtf16le(const char z){

46 int n = strlen(z);

47 char *z16;

48 int i, j;

49

50 z16 = malloc( n*2 + 2 );

51 for(i=j=0; i<=n; i++){

52 z16[j++] = z[i];

53 z16[j++] = 0;

54 }

55 return (void*)z16;

56 }

57

58 /*

59 ** Timers

60 */

61 static sqlite_uint64 prepTime = 0;

62 static sqlite_uint64 runTime = 0;

63 static sqlite_uint64 finalizeTime = 0;

64

65 /*

66 ** Prepare and run a single statement of SQL.

67 */

68 static void prepareAndRun(sqlite3 db, const char zSql){

69 void *utf16;

70 sqlite3_stmt *pStmt;

71 const void *stmtTail;

72 sqlite_uint64 iStart, iElapse;

73 int rc;

74

75 printf("****************************************************************\n");

76 printf("SQL statement: [%s]\n", zSql);

77 utf16 = asciiToUtf16le(zSql);

78 iStart = sqlite3Hwtime();

79 rc = sqlite3_prepare16_v2(db, utf16, -1, &pStmt, &stmtTail);

80 iElapse = sqlite3Hwtime() - iStart;

81 prepTime += iElapse;

82 printf("sqlite3_prepare16_v2() returns %d in %llu cycles\n", rc, iElapse);

83 if( rc==SQLITE_OK ){

84 int nRow = 0;

85 iStart = sqlite3Hwtime();

86 while( (rc=sqlite3_step(pStmt))==SQLITE_ROW ){ nRow++; }

87 iElapse = sqlite3Hwtime() - iStart;

88 runTime += iElapse;

89 printf("sqlite3_step() returns %d after %d rows in %llu cycles\n",

90 rc, nRow, iElapse);

91 iStart = sqlite3Hwtime();

92 rc = sqlite3_finalize(pStmt);

93 iElapse = sqlite3Hwtime() - iStart;

94 finalizeTime += iElapse;

95 printf("sqlite3_finalize() returns %d in %llu cycles\n", rc, iElapse);

96 }

97 free(utf16);

98 }

99

100 int main(int argc, char **argv){

101 void *utf16;

102 sqlite3 *db;

103 int rc;

104 int nSql;

105 char *zSql;

106 int i, j;

107 FILE *in;

108 sqlite_uint64 iStart, iElapse;

109 sqlite_uint64 iSetup = 0;

110 int nStmt = 0;

111 int nByte = 0;

112

113 if( argc!=3 ){

114 fprintf(stderr, "Usage: %s FILENAME SQL-SCRIPT\n"

115 "Runs SQL-SCRIPT as UTF16 against a UTF16 database\n",

116 argv[0]);

117 exit(1);

118 }

119 in = fopen(argv[2], "r");

120 fseek(in, 0L, SEEK_END);

121 nSql = ftell(in);

122 zSql = malloc( nSql+1 );

123 fseek(in, 0L, SEEK_SET);

124 nSql = fread(zSql, 1, nSql, in);

125 zSql[nSql] = 0;

126

127 printf("SQLite version: %d\n", sqlite3_libversion_number());

128 unlink(argv[1]);

129 utf16 = asciiToUtf16le(argv[1]);

130 iStart = sqlite3Hwtime();

131 rc = sqlite3_open16(utf16, &db);

132 iElapse = sqlite3Hwtime() - iStart;

133 iSetup = iElapse;

134 printf("sqlite3_open16() returns %d in %llu cycles\n", rc, iElapse);

135 free(utf16);

136 for(i=j=0; j<nSql; j++){

137 if( zSql[j]==';' ){

138 int isComplete;

139 char c = zSql[j+1];

140 zSql[j+1] = 0;

141 isComplete = sqlite3_complete(&zSql[i]);

142 zSql[j+1] = c;

143 if( isComplete ){

144 zSql[j] = 0;

145 while( i<j && ISSPACE(zSql[i]) ){ i++; }

146 if( i<j ){

147 nStmt++;

148 nByte += j-i;

149 prepareAndRun(db, &zSql[i]);

150 }

151 zSql[j] = ';';

152 i = j+1;

153 }

154 }

155 }

156 iStart = sqlite3Hwtime();

157 sqlite3_close(db);

158 iElapse = sqlite3Hwtime() - iStart;

159 iSetup += iElapse;

160 printf("sqlite3_close() returns in %llu cycles\n", iElapse);

161 printf("\n");

162 printf("Statements run: %15d\n", nStmt);

163 printf("Bytes of SQL text: %15d\n", nByte);

164 printf("Total prepare time: %15llu cycles\n", prepTime);

165 printf("Total run time: %15llu cycles\n", runTime);

166 printf("Total finalize time: %15llu cycles\n", finalizeTime);

167 printf("Open/Close time: %15llu cycles\n", iSetup);

168 printf("Total Time: %15llu cycles\n",

169 prepTime + runTime + finalizeTime + iSetup);

170 return 0;

171 }

OLD	NEW