?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
Roll src/third_party/WebKit a3b4a2e:7441784 (svn 202551:202552)
[chromium-blink-merge.git] / third_party / sqlite / src / test / wordcount.c
blobcf63e983c253e6f63071eabaa6801145151c863a
1 /*
2 ** This C program extracts all "words" from an input document and adds them
3 ** to an SQLite database. A "word" is any contiguous sequence of alphabetic
4 ** characters. All digits, punctuation, and whitespace characters are
5 ** word separators. The database stores a single entry for each distinct
6 ** word together with a count of the number of occurrences of that word.
7 ** A fresh database is created automatically on each run.
8 **
9 ** wordcount DATABASE INPUTFILE
10 **
11 ** The INPUTFILE name can be omitted, in which case input it taken from
12 ** standard input.
13 **
14 ** Option:
15 **
16 ** --without-rowid Use a WITHOUT ROWID table to store the words.
17 ** --insert Use INSERT mode (the default)
18 ** --replace Use REPLACE mode
19 ** --select Use SELECT mode
20 ** --update Use UPDATE mode
21 ** --delete Use DELETE mode
22 ** --query Use QUERY mode
23 ** --nocase Add the NOCASE collating sequence to the words.
24 ** --trace Enable sqlite3_trace() output.
25 ** --summary Show summary information on the collected data.
26 ** --stats Show sqlite3_status() results at the end.
27 ** --pagesize NNN Use a page size of NNN
28 ** --cachesize NNN Use a cache size of NNN
29 ** --commit NNN Commit after every NNN operations
30 ** --nosync Use PRAGMA synchronous=OFF
31 ** --journal MMMM Use PRAGMA journal_mode=MMMM
32 ** --timer Time the operation of this program
33 **
34 ** Modes:
35 **
36 ** Insert mode means:
37 ** (1) INSERT OR IGNORE INTO wordcount VALUES($new,1)
38 ** (2) UPDATE wordcount SET cnt=cnt+1 WHERE word=$new -- if (1) is a noop
39 **
40 ** Update mode means:
41 ** (1) INSERT OR IGNORE INTO wordcount VALUES($new,0)
42 ** (2) UPDATE wordcount SET cnt=cnt+1 WHERE word=$new
43 **
44 ** Replace mode means:
45 ** (1) REPLACE INTO wordcount
46 ** VALUES($new,ifnull((SELECT cnt FROM wordcount WHERE word=$new),0)+1);
47 **
48 ** Select mode means:
49 ** (1) SELECT 1 FROM wordcount WHERE word=$new
50 ** (2) INSERT INTO wordcount VALUES($new,1) -- if (1) returns nothing
51 ** (3) UPDATE wordcount SET cnt=cnt+1 WHERE word=$new --if (1) return TRUE
52 **
53 ** Delete mode means:
54 ** (1) DELETE FROM wordcount WHERE word=$new
55 **
56 ** Query mode means:
57 ** (1) SELECT cnt FROM wordcount WHERE word=$new
58 **
59 ** Note that delete mode and query mode are only useful for preexisting
60 ** databases. The wordcount table is created using IF NOT EXISTS so this
61 ** utility can be run multiple times on the same database file. The
62 ** --without-rowid, --nocase, and --pagesize parameters are only effective
63 ** when creating a new database and are harmless no-ops on preexisting
64 ** databases.
65 **
66 ******************************************************************************
67 **
68 ** Compile as follows:
69 **
70 ** gcc -I. wordcount.c sqlite3.c -ldl -lpthreads
71 **
72 ** Or:
73 **
74 ** gcc -I. -DSQLITE_THREADSAFE=0 -DSQLITE_OMIT_LOAD_EXTENSION \
75 ** wordcount.c sqlite3.c
76 */
77 #include <stdio.h>
78 #include <string.h>
79 #include <ctype.h>
80 #include <stdlib.h>
81 #include <stdarg.h>
82 #include "sqlite3.h"
83
84 /* Return the current wall-clock time */
85 static sqlite3_int64 realTime(void){
86 static sqlite3_vfs *clockVfs = 0;
87 sqlite3_int64 t;
88 if( clockVfs==0 ) clockVfs = sqlite3_vfs_find(0);
89 if( clockVfs->iVersion>=1 && clockVfs->xCurrentTimeInt64!=0 ){
90 clockVfs->xCurrentTimeInt64(clockVfs, &t);
91 }else{
92 double r;
93 clockVfs->xCurrentTime(clockVfs, &r);
94 t = (sqlite3_int64)(r*86400000.0);
95 }
96 return t;
97 }
98
99 /* Print an error message and exit */
100 static void fatal_error(const char *zMsg, ...){
101 va_list ap;
102 va_start(ap, zMsg);
103 vfprintf(stderr, zMsg, ap);
104 va_end(ap);
105 exit(1);
106 }
107
108 /* The sqlite3_trace() callback function */
109 static void traceCallback(void *NotUsed, const char *zSql){
110 printf("%s;\n", zSql);
111 }
112
113 /* An sqlite3_exec() callback that prints results on standard output,
114 ** each column separated by a single space. */
115 static int printResult(void *NotUsed, int nArg, char **azArg, char **azNm){
116 int i;
117 printf("--");
118 for(i=0; i<nArg; i++){
119 printf(" %s", azArg[i] ? azArg[i] : "(null)");
120 }
121 printf("\n");
122 return 0;
123 }
124
125
126 /*
127 ** Add one character to a hash
128 */
129 static void addCharToHash(unsigned int *a, unsigned char x){
130 if( a[0]<4 ){
131 a[1] = (a[1]<<8) | x;
132 a[0]++;
133 }else{
134 a[2] = (a[2]<<8) | x;
135 a[0]++;
136 if( a[0]==8 ){
137 a[3] += a[1] + a[4];
138 a[4] += a[2] + a[3];
139 a[0] = a[1] = a[2] = 0;
140 }
141 }
142 }
143
144 /*
145 ** Compute the final hash value.
146 */
147 static void finalHash(unsigned int *a, char *z){
148 a[3] += a[1] + a[4] + a[0];
149 a[4] += a[2] + a[3];
150 sqlite3_snprintf(17, z, "%08x%08x", a[3], a[4]);
151 }
152
153
154 /*
155 ** Implementation of a checksum() aggregate SQL function
156 */
157 static void checksumStep(
158 sqlite3_context *context,
159 int argc,
160 sqlite3_value **argv
161 ){
162 const unsigned char *zVal;
163 int nVal, i, j;
164 unsigned int *a;
165 a = (unsigned*)sqlite3_aggregate_context(context, sizeof(unsigned int)*5);
166
167 if( a ){
168 for(i=0; i<argc; i++){
169 nVal = sqlite3_value_bytes(argv[i]);
170 zVal = (const unsigned char*)sqlite3_value_text(argv[i]);
171 if( zVal ) for(j=0; j<nVal; j++) addCharToHash(a, zVal[j]);
172 addCharToHash(a, '|');
173 }
174 addCharToHash(a, '\n');
175 }
176 }
177 static void checksumFinalize(sqlite3_context *context){
178 unsigned int *a;
179 char zResult[24];
180 a = sqlite3_aggregate_context(context, 0);
181 if( a ){
182 finalHash(a, zResult);
183 sqlite3_result_text(context, zResult, -1, SQLITE_TRANSIENT);
184 }
185 }
186
187
188 /* Define operating modes */
189 #define MODE_INSERT 0
190 #define MODE_REPLACE 1
191 #define MODE_SELECT 2
192 #define MODE_UPDATE 3
193 #define MODE_DELETE 4
194 #define MODE_QUERY 5
195
196 int main(int argc, char **argv){
197 const char *zFileToRead = 0; /* Input file. NULL for stdin */
198 const char *zDbName = 0; /* Name of the database file to create */
199 int useWithoutRowid = 0; /* True for --without-rowid */
200 int iMode = MODE_INSERT; /* One of MODE_xxxxx */
201 int useNocase = 0; /* True for --nocase */
202 int doTrace = 0; /* True for --trace */
203 int showStats = 0; /* True for --stats */
204 int showSummary = 0; /* True for --summary */
205 int showTimer = 0; /* True for --timer */
206 int cacheSize = 0; /* Desired cache size. 0 means default */
207 int pageSize = 0; /* Desired page size. 0 means default */
208 int commitInterval = 0; /* How often to commit. 0 means never */
209 int noSync = 0; /* True for --nosync */
210 const char *zJMode = 0; /* Journal mode */
211 int nOp = 0; /* Operation counter */
212 int i, j; /* Loop counters */
213 sqlite3 *db; /* The SQLite database connection */
214 char *zSql; /* Constructed SQL statement */
215 sqlite3_stmt *pInsert = 0; /* The INSERT statement */
216 sqlite3_stmt *pUpdate = 0; /* The UPDATE statement */
217 sqlite3_stmt *pSelect = 0; /* The SELECT statement */
218 sqlite3_stmt *pDelete = 0; /* The DELETE statement */
219 FILE *in; /* The open input file */
220 int rc; /* Return code from an SQLite interface */
221 int iCur, iHiwtr; /* Statistics values, current and "highwater" */
222 sqlite3_int64 sumCnt = 0; /* Sum in QUERY mode */
223 sqlite3_int64 startTime;
224 char zInput[2000]; /* A single line of input */
225
226 /* Process command-line arguments */
227 for(i=1; i<argc; i++){
228 const char *z = argv[i];
229 if( z[0]=='-' ){
230 do{ z++; }while( z[0]=='-' );
231 if( strcmp(z,"without-rowid")==0 ){
232 useWithoutRowid = 1;
233 }else if( strcmp(z,"replace")==0 ){
234 iMode = MODE_REPLACE;
235 }else if( strcmp(z,"select")==0 ){
236 iMode = MODE_SELECT;
237 }else if( strcmp(z,"insert")==0 ){
238 iMode = MODE_INSERT;
239 }else if( strcmp(z,"update")==0 ){
240 iMode = MODE_UPDATE;
241 }else if( strcmp(z,"delete")==0 ){
242 iMode = MODE_DELETE;
243 }else if( strcmp(z,"query")==0 ){
244 iMode = MODE_QUERY;
245 }else if( strcmp(z,"nocase")==0 ){
246 useNocase = 1;
247 }else if( strcmp(z,"trace")==0 ){
248 doTrace = 1;
249 }else if( strcmp(z,"nosync")==0 ){
250 noSync = 1;
251 }else if( strcmp(z,"stats")==0 ){
252 showStats = 1;
253 }else if( strcmp(z,"summary")==0 ){
254 showSummary = 1;
255 }else if( strcmp(z,"timer")==0 ){
256 showTimer = i;
257 }else if( strcmp(z,"cachesize")==0 && i<argc-1 ){
258 i++;
259 cacheSize = atoi(argv[i]);
260 }else if( strcmp(z,"pagesize")==0 && i<argc-1 ){
261 i++;
262 pageSize = atoi(argv[i]);
263 }else if( strcmp(z,"commit")==0 && i<argc-1 ){
264 i++;
265 commitInterval = atoi(argv[i]);
266 }else if( strcmp(z,"journal")==0 && i<argc-1 ){
267 zJMode = argv[++i];
268 }else{
269 fatal_error("unknown option: %s\n", argv[i]);
270 }
271 }else if( zDbName==0 ){
272 zDbName = argv[i];
273 }else if( zFileToRead==0 ){
274 zFileToRead = argv[i];
275 }else{
276 fatal_error("surplus argument: %s\n", argv[i]);
277 }
278 }
279 if( zDbName==0 ){
280 fatal_error("Usage: %s [--options] DATABASE [INPUTFILE]\n", argv[0]);
281 }
282 startTime = realTime();
283
284 /* Open the database and the input file */
285 if( sqlite3_open(zDbName, &db) ){
286 fatal_error("Cannot open database file: %s\n", zDbName);
287 }
288 if( zFileToRead ){
289 in = fopen(zFileToRead, "rb");
290 if( in==0 ){
291 fatal_error("Could not open input file \"%s\"\n", zFileToRead);
292 }
293 }else{
294 in = stdin;
295 }
296
297 /* Set database connection options */
298 if( doTrace ) sqlite3_trace(db, traceCallback, 0);
299 if( pageSize ){
300 zSql = sqlite3_mprintf("PRAGMA page_size=%d", pageSize);
301 sqlite3_exec(db, zSql, 0, 0, 0);
302 sqlite3_free(zSql);
303 }
304 if( cacheSize ){
305 zSql = sqlite3_mprintf("PRAGMA cache_size=%d", cacheSize);
306 sqlite3_exec(db, zSql, 0, 0, 0);
307 sqlite3_free(zSql);
308 }
309 if( noSync ) sqlite3_exec(db, "PRAGMA synchronous=OFF", 0, 0, 0);
310 if( zJMode ){
311 zSql = sqlite3_mprintf("PRAGMA journal_mode=%s", zJMode);
312 sqlite3_exec(db, zSql, 0, 0, 0);
313 sqlite3_free(zSql);
314 }
315
316
317 /* Construct the "wordcount" table into which to put the words */
318 if( sqlite3_exec(db, "BEGIN IMMEDIATE", 0, 0, 0) ){
319 fatal_error("Could not start a transaction\n");
320 }
321 zSql = sqlite3_mprintf(
322 "CREATE TABLE IF NOT EXISTS wordcount(\n"
323 " word TEXT PRIMARY KEY COLLATE %s,\n"
324 " cnt INTEGER\n"
325 ")%s",
326 useNocase ? "nocase" : "binary",
327 useWithoutRowid ? " WITHOUT ROWID" : ""
328 );
329 if( zSql==0 ) fatal_error("out of memory\n");
330 rc = sqlite3_exec(db, zSql, 0, 0, 0);
331 if( rc ) fatal_error("Could not create the wordcount table: %s.\n",
332 sqlite3_errmsg(db));
333 sqlite3_free(zSql);
334
335 /* Prepare SQL statements that will be needed */
336 if( iMode==MODE_QUERY ){
337 rc = sqlite3_prepare_v2(db,
338 "SELECT cnt FROM wordcount WHERE word=?1",
339 -1, &pSelect, 0);
340 if( rc ) fatal_error("Could not prepare the SELECT statement: %s\n",
341 sqlite3_errmsg(db));
342 }
343 if( iMode==MODE_SELECT ){
344 rc = sqlite3_prepare_v2(db,
345 "SELECT 1 FROM wordcount WHERE word=?1",
346 -1, &pSelect, 0);
347 if( rc ) fatal_error("Could not prepare the SELECT statement: %s\n",
348 sqlite3_errmsg(db));
349 rc = sqlite3_prepare_v2(db,
350 "INSERT INTO wordcount(word,cnt) VALUES(?1,1)",
351 -1, &pInsert, 0);
352 if( rc ) fatal_error("Could not prepare the INSERT statement: %s\n",
353 sqlite3_errmsg(db));
354 }
355 if( iMode==MODE_SELECT || iMode==MODE_UPDATE || iMode==MODE_INSERT ){
356 rc = sqlite3_prepare_v2(db,
357 "UPDATE wordcount SET cnt=cnt+1 WHERE word=?1",
358 -1, &pUpdate, 0);
359 if( rc ) fatal_error("Could not prepare the UPDATE statement: %s\n",
360 sqlite3_errmsg(db));
361 }
362 if( iMode==MODE_INSERT ){
363 rc = sqlite3_prepare_v2(db,
364 "INSERT OR IGNORE INTO wordcount(word,cnt) VALUES(?1,1)",
365 -1, &pInsert, 0);
366 if( rc ) fatal_error("Could not prepare the INSERT statement: %s\n",
367 sqlite3_errmsg(db));
368 }
369 if( iMode==MODE_UPDATE ){
370 rc = sqlite3_prepare_v2(db,
371 "INSERT OR IGNORE INTO wordcount(word,cnt) VALUES(?1,0)",
372 -1, &pInsert, 0);
373 if( rc ) fatal_error("Could not prepare the INSERT statement: %s\n",
374 sqlite3_errmsg(db));
375 }
376 if( iMode==MODE_REPLACE ){
377 rc = sqlite3_prepare_v2(db,
378 "REPLACE INTO wordcount(word,cnt)"
379 "VALUES(?1,coalesce((SELECT cnt FROM wordcount WHERE word=?1),0)+1)",
380 -1, &pInsert, 0);
381 if( rc ) fatal_error("Could not prepare the REPLACE statement: %s\n",
382 sqlite3_errmsg(db));
383 }
384 if( iMode==MODE_DELETE ){
385 rc = sqlite3_prepare_v2(db,
386 "DELETE FROM wordcount WHERE word=?1",
387 -1, &pDelete, 0);
388 if( rc ) fatal_error("Could not prepare the DELETE statement: %s\n",
389 sqlite3_errmsg(db));
390 }
391
392 /* Process the input file */
393 while( fgets(zInput, sizeof(zInput), in) ){
394 for(i=0; zInput[i]; i++){
395 if( !isalpha(zInput[i]) ) continue;
396 for(j=i+1; isalpha(zInput[j]); j++){}
397
398 /* Found a new word at zInput[i] that is j-i bytes long.
399 ** Process it into the wordcount table. */
400 if( iMode==MODE_DELETE ){
401 sqlite3_bind_text(pDelete, 1, zInput+i, j-i, SQLITE_STATIC);
402 if( sqlite3_step(pDelete)!=SQLITE_DONE ){
403 fatal_error("DELETE failed: %s\n", sqlite3_errmsg(db));
404 }
405 sqlite3_reset(pDelete);
406 }else if( iMode==MODE_SELECT ){
407 sqlite3_bind_text(pSelect, 1, zInput+i, j-i, SQLITE_STATIC);
408 rc = sqlite3_step(pSelect);
409 sqlite3_reset(pSelect);
410 if( rc==SQLITE_ROW ){
411 sqlite3_bind_text(pUpdate, 1, zInput+i, j-i, SQLITE_STATIC);
412 if( sqlite3_step(pUpdate)!=SQLITE_DONE ){
413 fatal_error("UPDATE failed: %s\n", sqlite3_errmsg(db));
414 }
415 sqlite3_reset(pUpdate);
416 }else if( rc==SQLITE_DONE ){
417 sqlite3_bind_text(pInsert, 1, zInput+i, j-i, SQLITE_STATIC);
418 if( sqlite3_step(pInsert)!=SQLITE_DONE ){
419 fatal_error("Insert failed: %s\n", sqlite3_errmsg(db));
420 }
421 sqlite3_reset(pInsert);
422 }else{
423 fatal_error("SELECT failed: %s\n", sqlite3_errmsg(db));
424 }
425 }else if( iMode==MODE_QUERY ){
426 sqlite3_bind_text(pSelect, 1, zInput+i, j-i, SQLITE_STATIC);
427 if( sqlite3_step(pSelect)==SQLITE_ROW ){
428 sumCnt += sqlite3_column_int64(pSelect, 0);
429 }
430 sqlite3_reset(pSelect);
431 }else{
432 sqlite3_bind_text(pInsert, 1, zInput+i, j-i, SQLITE_STATIC);
433 if( sqlite3_step(pInsert)!=SQLITE_DONE ){
434 fatal_error("INSERT failed: %s\n", sqlite3_errmsg(db));
435 }
436 sqlite3_reset(pInsert);
437 if( iMode==MODE_UPDATE
438 || (iMode==MODE_INSERT && sqlite3_changes(db)==0)
439 ){
440 sqlite3_bind_text(pUpdate, 1, zInput+i, j-i, SQLITE_STATIC);
441 if( sqlite3_step(pUpdate)!=SQLITE_DONE ){
442 fatal_error("UPDATE failed: %s\n", sqlite3_errmsg(db));
443 }
444 sqlite3_reset(pUpdate);
445 }
446 }
447 i = j-1;
448
449 /* Increment the operation counter. Do a COMMIT if it is time. */
450 nOp++;
451 if( commitInterval>0 && (nOp%commitInterval)==0 ){
452 sqlite3_exec(db, "COMMIT; BEGIN IMMEDIATE", 0, 0, 0);
453 }
454 }
455 }
456 sqlite3_exec(db, "COMMIT", 0, 0, 0);
457 if( zFileToRead ) fclose(in);
458 sqlite3_finalize(pInsert);
459 sqlite3_finalize(pUpdate);
460 sqlite3_finalize(pSelect);
461 sqlite3_finalize(pDelete);
462
463 if( iMode==MODE_QUERY ){
464 printf("sum of cnt: %lld\n", sumCnt);
465 rc = sqlite3_prepare_v2(db,"SELECT sum(cnt*cnt) FROM wordcount", -1,
466 &pSelect, 0);
467 if( rc==SQLITE_OK && sqlite3_step(pSelect)==SQLITE_ROW ){
468 printf("double-check: %lld\n", sqlite3_column_int64(pSelect, 0));
469 }
470 sqlite3_finalize(pSelect);
471 }
472
473
474 if( showTimer ){
475 sqlite3_int64 elapseTime = realTime() - startTime;
476 fprintf(stderr, "%3d.%03d wordcount", (int)(elapseTime/1000),
477 (int)(elapseTime%1000));
478 for(i=1; i<argc; i++) if( i!=showTimer ) fprintf(stderr, " %s", argv[i]);
479 fprintf(stderr, "\n");
480 }
481
482 if( showSummary ){
483 sqlite3_create_function(db, "checksum", -1, SQLITE_UTF8, 0,
484 0, checksumStep, checksumFinalize);
485 sqlite3_exec(db,
486 "SELECT 'count(*): ', count(*) FROM wordcount;\n"
487 "SELECT 'sum(cnt): ', sum(cnt) FROM wordcount;\n"
488 "SELECT 'max(cnt): ', max(cnt) FROM wordcount;\n"
489 "SELECT 'avg(cnt): ', avg(cnt) FROM wordcount;\n"
490 "SELECT 'sum(cnt=1):', sum(cnt=1) FROM wordcount;\n"
491 "SELECT 'top 10: ', group_concat(word, ', ') FROM "
492 "(SELECT word FROM wordcount ORDER BY cnt DESC, word LIMIT 10);\n"
493 "SELECT 'checksum: ', checksum(word, cnt) FROM "
494 "(SELECT word, cnt FROM wordcount ORDER BY word);\n"
495 "PRAGMA integrity_check;\n",
496 printResult, 0, 0);
497 }
498
499 /* Database connection statistics printed after both prepared statements
500 ** have been finalized */
501 if( showStats ){
502 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_USED, &iCur, &iHiwtr, 0);
503 printf("-- Lookaside Slots Used: %d (max %d)\n", iCur,iHiwtr);
504 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_HIT, &iCur, &iHiwtr, 0);
505 printf("-- Successful lookasides: %d\n", iHiwtr);
506 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE, &iCur,&iHiwtr,0);
507 printf("-- Lookaside size faults: %d\n", iHiwtr);
508 sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL, &iCur,&iHiwtr,0);
509 printf("-- Lookaside OOM faults: %d\n", iHiwtr);
510 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_USED, &iCur, &iHiwtr, 0);
511 printf("-- Pager Heap Usage: %d bytes\n", iCur);
512 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_HIT, &iCur, &iHiwtr, 1);
513 printf("-- Page cache hits: %d\n", iCur);
514 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_MISS, &iCur, &iHiwtr, 1);
515 printf("-- Page cache misses: %d\n", iCur);
516 sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_WRITE, &iCur, &iHiwtr, 1);
517 printf("-- Page cache writes: %d\n", iCur);
518 sqlite3_db_status(db, SQLITE_DBSTATUS_SCHEMA_USED, &iCur, &iHiwtr, 0);
519 printf("-- Schema Heap Usage: %d bytes\n", iCur);
520 sqlite3_db_status(db, SQLITE_DBSTATUS_STMT_USED, &iCur, &iHiwtr, 0);
521 printf("-- Statement Heap Usage: %d bytes\n", iCur);
522 }
523
524 sqlite3_close(db);
525
526 /* Global memory usage statistics printed after the database connection
527 ** has closed. Memory usage should be zero at this point. */
528 if( showStats ){
529 sqlite3_status(SQLITE_STATUS_MEMORY_USED, &iCur, &iHiwtr, 0);
530 printf("-- Memory Used (bytes): %d (max %d)\n", iCur,iHiwtr);
531 sqlite3_status(SQLITE_STATUS_MALLOC_COUNT, &iCur, &iHiwtr, 0);
532 printf("-- Outstanding Allocations: %d (max %d)\n", iCur,iHiwtr);
533 sqlite3_status(SQLITE_STATUS_PAGECACHE_OVERFLOW, &iCur, &iHiwtr, 0);
534 printf("-- Pcache Overflow Bytes: %d (max %d)\n", iCur,iHiwtr);
535 sqlite3_status(SQLITE_STATUS_SCRATCH_OVERFLOW, &iCur, &iHiwtr, 0);
536 printf("-- Scratch Overflow Bytes: %d (max %d)\n", iCur,iHiwtr);
537 sqlite3_status(SQLITE_STATUS_MALLOC_SIZE, &iCur, &iHiwtr, 0);
538 printf("-- Largest Allocation: %d bytes\n",iHiwtr);
539 sqlite3_status(SQLITE_STATUS_PAGECACHE_SIZE, &iCur, &iHiwtr, 0);
540 printf("-- Largest Pcache Allocation: %d bytes\n",iHiwtr);
541 sqlite3_status(SQLITE_STATUS_SCRATCH_SIZE, &iCur, &iHiwtr, 0);
542 printf("-- Largest Scratch Allocation: %d bytes\n", iHiwtr);
543 }
544 return 0;
545 }