mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 16:49:47 +00:00
1138 lines
35 KiB
C
1138 lines
35 KiB
C
/*
|
|
** 2016-12-28
|
|
**
|
|
** The author disclaims copyright to this source code. In place of
|
|
** a legal notice, here is a blessing:
|
|
**
|
|
** May you do good and not evil.
|
|
** May you find forgiveness for yourself and forgive others.
|
|
** May you share freely, never taking more than you give.
|
|
**
|
|
*************************************************************************
|
|
**
|
|
** This file implements "key-value" performance test for SQLite. The
|
|
** purpose is to compare the speed of SQLite for accessing large BLOBs
|
|
** versus reading those same BLOB values out of individual files in the
|
|
** filesystem.
|
|
**
|
|
** Run "kvtest" with no arguments for on-line help, or see comments below.
|
|
**
|
|
** HOW TO COMPILE:
|
|
**
|
|
** (1) Gather this source file and a recent SQLite3 amalgamation with its
|
|
** header into the working directory. You should have:
|
|
**
|
|
** kvtest.c >--- this file
|
|
** sqlite3.c \___ SQLite
|
|
** sqlite3.h / amlagamation & header
|
|
**
|
|
** (2) Run you compiler against the two C source code files.
|
|
**
|
|
** (a) On linux or mac:
|
|
**
|
|
** OPTS="-DSQLITE_THREADSAFE=0 -DSQLITE_OMIT_LOAD_EXTENSION"
|
|
** gcc -Os -I. $OPTS kvtest.c sqlite3.c -o kvtest
|
|
**
|
|
** The $OPTS options can be omitted. The $OPTS merely omit
|
|
** the need to link against -ldl and -lpthread, or whatever
|
|
** the equivalent libraries are called on your system.
|
|
**
|
|
** (b) Windows with MSVC:
|
|
**
|
|
** cl -I. kvtest.c sqlite3.c
|
|
**
|
|
** USAGE:
|
|
**
|
|
** (1) Create a test database by running "kvtest init" with appropriate
|
|
** options. See the help message for available options.
|
|
**
|
|
** (2) Construct the corresponding pile-of-files database on disk using
|
|
** the "kvtest export" command.
|
|
**
|
|
** (3) Run tests using "kvtest run" against either the SQLite database or
|
|
** the pile-of-files database and with appropriate options.
|
|
**
|
|
** For example:
|
|
**
|
|
** ./kvtest init x1.db --count 100000 --size 10000
|
|
** mkdir x1
|
|
** ./kvtest export x1.db x1
|
|
** ./kvtest run x1.db --count 10000 --max-id 1000000
|
|
** ./kvtest run x1 --count 10000 --max-id 1000000
|
|
*/
|
|
static const char zHelp[] =
|
|
"Usage: kvtest COMMAND ARGS...\n"
|
|
"\n"
|
|
" kvtest init DBFILE --count N --size M --pagesize X\n"
|
|
"\n"
|
|
" Generate a new test database file named DBFILE containing N\n"
|
|
" BLOBs each of size M bytes. The page size of the new database\n"
|
|
" file will be X. Additional options:\n"
|
|
"\n"
|
|
" --variance V Randomly vary M by plus or minus V\n"
|
|
"\n"
|
|
" kvtest export DBFILE DIRECTORY [--tree]\n"
|
|
"\n"
|
|
" Export all the blobs in the kv table of DBFILE into separate\n"
|
|
" files in DIRECTORY. DIRECTORY is created if it does not previously\n"
|
|
" exist. If the --tree option is used, then the blobs are written\n"
|
|
" into a hierarchy of directories, using names like 00/00/00,\n"
|
|
" 00/00/01, 00/00/02, and so forth. Without the --tree option, all\n"
|
|
" files are in the top-level directory with names like 000000, 000001,\n"
|
|
" 000002, and so forth.\n"
|
|
"\n"
|
|
" kvtest stat DBFILE [options]\n"
|
|
"\n"
|
|
" Display summary information about DBFILE. Options:\n"
|
|
"\n"
|
|
" --vacuum Run VACUUM on the database file\n"
|
|
"\n"
|
|
" kvtest run DBFILE [options]\n"
|
|
"\n"
|
|
" Run a performance test. DBFILE can be either the name of a\n"
|
|
" database or a directory containing sample files. Options:\n"
|
|
"\n"
|
|
" --asc Read blobs in ascending order\n"
|
|
" --blob-api Use the BLOB API\n"
|
|
" --cache-size N Database cache size\n"
|
|
" --count N Read N blobs\n"
|
|
" --desc Read blobs in descending order\n"
|
|
" --fsync Synchronous file writes\n"
|
|
" --integrity-check Run \"PRAGMA integrity_check\" after test\n"
|
|
" --max-id N Maximum blob key to use\n"
|
|
" --mmap N Mmap as much as N bytes of DBFILE\n"
|
|
" --multitrans Each read or write in its own transaction\n"
|
|
" --nocheckpoint Omit the checkpoint on WAL mode writes\n"
|
|
" --nosync Set \"PRAGMA synchronous=OFF\"\n"
|
|
" --jmode MODE Set MODE journal mode prior to starting\n"
|
|
" --random Read blobs in a random order\n"
|
|
" --start N Start reading with this blob key\n"
|
|
" --stats Output operating stats before exiting\n"
|
|
" --update Do an overwrite test\n"
|
|
;
|
|
|
|
/* Reference resources used */
|
|
#include <stdio.h>
|
|
#include <stdlib.h>
|
|
#include <sys/types.h>
|
|
#include <sys/stat.h>
|
|
#include <assert.h>
|
|
#include <string.h>
|
|
#include "sqlite3.h"
|
|
|
|
#ifndef _WIN32
|
|
# include <unistd.h>
|
|
#else
|
|
/* Provide Windows equivalent for the needed parts of unistd.h */
|
|
# include <direct.h>
|
|
# include <io.h>
|
|
# define R_OK 2
|
|
# define S_ISREG(m) (((m) & S_IFMT) == S_IFREG)
|
|
# define S_ISDIR(m) (((m) & S_IFMT) == S_IFDIR)
|
|
# define access _access
|
|
#endif
|
|
|
|
#if !defined(_MSC_VER)
|
|
# include <stdint.h>
|
|
#endif
|
|
|
|
/*
|
|
** The following macros are used to cast pointers to integers and
|
|
** integers to pointers. The way you do this varies from one compiler
|
|
** to the next, so we have developed the following set of #if statements
|
|
** to generate appropriate macros for a wide range of compilers.
|
|
**
|
|
** The correct "ANSI" way to do this is to use the intptr_t type.
|
|
** Unfortunately, that typedef is not available on all compilers, or
|
|
** if it is available, it requires an #include of specific headers
|
|
** that vary from one machine to the next.
|
|
**
|
|
** Ticket #3860: The llvm-gcc-4.2 compiler from Apple chokes on
|
|
** the ((void*)&((char*)0)[X]) construct. But MSVC chokes on ((void*)(X)).
|
|
** So we have to define the macros in different ways depending on the
|
|
** compiler.
|
|
*/
|
|
#if defined(__PTRDIFF_TYPE__) /* This case should work for GCC */
|
|
# define SQLITE_INT_TO_PTR(X) ((void*)(__PTRDIFF_TYPE__)(X))
|
|
# define SQLITE_PTR_TO_INT(X) ((sqlite3_int64)(__PTRDIFF_TYPE__)(X))
|
|
#else
|
|
# define SQLITE_INT_TO_PTR(X) ((void*)(intptr_t)(X))
|
|
# define SQLITE_PTR_TO_INT(X) ((sqlite3_int64)(intptr_t)(X))
|
|
#endif
|
|
|
|
/*
|
|
** Show the help text and quit.
|
|
*/
|
|
static void showHelp(void){
|
|
fprintf(stdout, "%s", zHelp);
|
|
exit(1);
|
|
}
|
|
|
|
/*
|
|
** Show an error message an quit.
|
|
*/
|
|
static void fatalError(const char *zFormat, ...){
|
|
va_list ap;
|
|
fprintf(stdout, "ERROR: ");
|
|
va_start(ap, zFormat);
|
|
vfprintf(stdout, zFormat, ap);
|
|
va_end(ap);
|
|
fprintf(stdout, "\n");
|
|
exit(1);
|
|
}
|
|
|
|
/*
|
|
** Return the value of a hexadecimal digit. Return -1 if the input
|
|
** is not a hex digit.
|
|
*/
|
|
static int hexDigitValue(char c){
|
|
if( c>='0' && c<='9' ) return c - '0';
|
|
if( c>='a' && c<='f' ) return c - 'a' + 10;
|
|
if( c>='A' && c<='F' ) return c - 'A' + 10;
|
|
return -1;
|
|
}
|
|
|
|
/*
|
|
** Interpret zArg as an integer value, possibly with suffixes.
|
|
*/
|
|
static int integerValue(const char *zArg){
|
|
int v = 0;
|
|
static const struct { char *zSuffix; int iMult; } aMult[] = {
|
|
{ "KiB", 1024 },
|
|
{ "MiB", 1024*1024 },
|
|
{ "GiB", 1024*1024*1024 },
|
|
{ "KB", 1000 },
|
|
{ "MB", 1000000 },
|
|
{ "GB", 1000000000 },
|
|
{ "K", 1000 },
|
|
{ "M", 1000000 },
|
|
{ "G", 1000000000 },
|
|
};
|
|
int i;
|
|
int isNeg = 0;
|
|
if( zArg[0]=='-' ){
|
|
isNeg = 1;
|
|
zArg++;
|
|
}else if( zArg[0]=='+' ){
|
|
zArg++;
|
|
}
|
|
if( zArg[0]=='0' && zArg[1]=='x' ){
|
|
int x;
|
|
zArg += 2;
|
|
while( (x = hexDigitValue(zArg[0]))>=0 ){
|
|
v = (v<<4) + x;
|
|
zArg++;
|
|
}
|
|
}else{
|
|
while( zArg[0]>='0' && zArg[0]<='9' ){
|
|
v = v*10 + zArg[0] - '0';
|
|
zArg++;
|
|
}
|
|
}
|
|
for(i=0; i<sizeof(aMult)/sizeof(aMult[0]); i++){
|
|
if( sqlite3_stricmp(aMult[i].zSuffix, zArg)==0 ){
|
|
v *= aMult[i].iMult;
|
|
break;
|
|
}
|
|
}
|
|
return isNeg? -v : v;
|
|
}
|
|
|
|
|
|
/*
|
|
** Check the filesystem object zPath. Determine what it is:
|
|
**
|
|
** PATH_DIR A single directory holding many files
|
|
** PATH_TREE A directory hierarchy with files at the leaves
|
|
** PATH_DB An SQLite database
|
|
** PATH_NEXIST Does not exist
|
|
** PATH_OTHER Something else
|
|
**
|
|
** PATH_DIR means all of the separate files are grouped together
|
|
** into a single directory with names like 000000, 000001, 000002, and
|
|
** so forth. PATH_TREE means there is a hierarchy of directories so
|
|
** that no single directory has too many entries. The files have names
|
|
** like 00/00/00, 00/00/01, 00/00/02 and so forth. The decision between
|
|
** PATH_DIR and PATH_TREE is determined by the presence of a subdirectory
|
|
** named "00" at the top-level.
|
|
*/
|
|
#define PATH_DIR 1
|
|
#define PATH_TREE 2
|
|
#define PATH_DB 3
|
|
#define PATH_NEXIST 0
|
|
#define PATH_OTHER 99
|
|
static int pathType(const char *zPath){
|
|
struct stat x;
|
|
int rc;
|
|
if( access(zPath,R_OK) ) return PATH_NEXIST;
|
|
memset(&x, 0, sizeof(x));
|
|
rc = stat(zPath, &x);
|
|
if( rc<0 ) return PATH_OTHER;
|
|
if( S_ISDIR(x.st_mode) ){
|
|
char *zLayer1 = sqlite3_mprintf("%s/00", zPath);
|
|
memset(&x, 0, sizeof(x));
|
|
rc = stat(zLayer1, &x);
|
|
sqlite3_free(zLayer1);
|
|
if( rc<0 ) return PATH_DIR;
|
|
if( S_ISDIR(x.st_mode) ) return PATH_TREE;
|
|
return PATH_DIR;
|
|
}
|
|
if( (x.st_size%512)==0 ) return PATH_DB;
|
|
return PATH_OTHER;
|
|
}
|
|
|
|
/*
|
|
** Return the size of a file in bytes. Or return -1 if the
|
|
** named object is not a regular file or does not exist.
|
|
*/
|
|
static sqlite3_int64 fileSize(const char *zPath){
|
|
struct stat x;
|
|
int rc;
|
|
memset(&x, 0, sizeof(x));
|
|
rc = stat(zPath, &x);
|
|
if( rc<0 ) return -1;
|
|
if( !S_ISREG(x.st_mode) ) return -1;
|
|
return x.st_size;
|
|
}
|
|
|
|
/*
|
|
** A Pseudo-random number generator with a fixed seed. Use this so
|
|
** that the same sequence of "random" numbers are generated on each
|
|
** run, for repeatability.
|
|
*/
|
|
static unsigned int randInt(void){
|
|
static unsigned int x = 0x333a13cd;
|
|
static unsigned int y = 0xecb2adea;
|
|
x = (x>>1) ^ ((1+~(x&1)) & 0xd0000001);
|
|
y = y*1103515245 + 12345;
|
|
return x^y;
|
|
}
|
|
|
|
/*
|
|
** Do database initialization.
|
|
*/
|
|
static int initMain(int argc, char **argv){
|
|
char *zDb;
|
|
int i, rc;
|
|
int nCount = 1000;
|
|
int sz = 10000;
|
|
int iVariance = 0;
|
|
int pgsz = 4096;
|
|
sqlite3 *db;
|
|
char *zSql;
|
|
char *zErrMsg = 0;
|
|
|
|
assert( strcmp(argv[1],"init")==0 );
|
|
assert( argc>=3 );
|
|
zDb = argv[2];
|
|
for(i=3; i<argc; i++){
|
|
char *z = argv[i];
|
|
if( z[0]!='-' ) fatalError("unknown argument: \"%s\"", z);
|
|
if( z[1]=='-' ) z++;
|
|
if( strcmp(z, "-count")==0 ){
|
|
if( i==argc-1 ) fatalError("missing argument on \"%s\"", argv[i]);
|
|
nCount = integerValue(argv[++i]);
|
|
if( nCount<1 ) fatalError("the --count must be positive");
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-size")==0 ){
|
|
if( i==argc-1 ) fatalError("missing argument on \"%s\"", argv[i]);
|
|
sz = integerValue(argv[++i]);
|
|
if( sz<1 ) fatalError("the --size must be positive");
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-variance")==0 ){
|
|
if( i==argc-1 ) fatalError("missing argument on \"%s\"", argv[i]);
|
|
iVariance = integerValue(argv[++i]);
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-pagesize")==0 ){
|
|
if( i==argc-1 ) fatalError("missing argument on \"%s\"", argv[i]);
|
|
pgsz = integerValue(argv[++i]);
|
|
if( pgsz<512 || pgsz>65536 || ((pgsz-1)&pgsz)!=0 ){
|
|
fatalError("the --pagesize must be power of 2 between 512 and 65536");
|
|
}
|
|
continue;
|
|
}
|
|
fatalError("unknown option: \"%s\"", argv[i]);
|
|
}
|
|
rc = sqlite3_open(zDb, &db);
|
|
if( rc ){
|
|
fatalError("cannot open database \"%s\": %s", zDb, sqlite3_errmsg(db));
|
|
}
|
|
zSql = sqlite3_mprintf(
|
|
"DROP TABLE IF EXISTS kv;\n"
|
|
"PRAGMA page_size=%d;\n"
|
|
"VACUUM;\n"
|
|
"BEGIN;\n"
|
|
"CREATE TABLE kv(k INTEGER PRIMARY KEY, v BLOB);\n"
|
|
"WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<%d)"
|
|
" INSERT INTO kv(k,v) SELECT x, randomblob(%d+(random()%%(%d))) FROM c;\n"
|
|
"COMMIT;\n",
|
|
pgsz, nCount, sz, iVariance+1
|
|
);
|
|
rc = sqlite3_exec(db, zSql, 0, 0, &zErrMsg);
|
|
if( rc ) fatalError("database create failed: %s", zErrMsg);
|
|
sqlite3_free(zSql);
|
|
sqlite3_close(db);
|
|
return 0;
|
|
}
|
|
|
|
/*
|
|
** Analyze an existing database file. Report its content.
|
|
*/
|
|
static int statMain(int argc, char **argv){
|
|
char *zDb;
|
|
int i, rc;
|
|
sqlite3 *db;
|
|
char *zSql;
|
|
sqlite3_stmt *pStmt;
|
|
int doVacuum = 0;
|
|
|
|
assert( strcmp(argv[1],"stat")==0 );
|
|
assert( argc>=3 );
|
|
zDb = argv[2];
|
|
for(i=3; i<argc; i++){
|
|
char *z = argv[i];
|
|
if( z[0]!='-' ) fatalError("unknown argument: \"%s\"", z);
|
|
if( z[1]=='-' ) z++;
|
|
if( strcmp(z, "-vacuum")==0 ){
|
|
doVacuum = 1;
|
|
continue;
|
|
}
|
|
fatalError("unknown option: \"%s\"", argv[i]);
|
|
}
|
|
rc = sqlite3_open(zDb, &db);
|
|
if( rc ){
|
|
fatalError("cannot open database \"%s\": %s", zDb, sqlite3_errmsg(db));
|
|
}
|
|
if( doVacuum ){
|
|
printf("Vacuuming...."); fflush(stdout);
|
|
sqlite3_exec(db, "VACUUM", 0, 0, 0);
|
|
printf(" done\n");
|
|
}
|
|
zSql = sqlite3_mprintf(
|
|
"SELECT count(*), min(length(v)), max(length(v)), avg(length(v))"
|
|
" FROM kv"
|
|
);
|
|
rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
|
|
if( rc ) fatalError("cannot prepare SQL [%s]: %s", zSql, sqlite3_errmsg(db));
|
|
sqlite3_free(zSql);
|
|
if( sqlite3_step(pStmt)==SQLITE_ROW ){
|
|
printf("Number of entries: %8d\n", sqlite3_column_int(pStmt, 0));
|
|
printf("Average value size: %8d\n", sqlite3_column_int(pStmt, 3));
|
|
printf("Minimum value size: %8d\n", sqlite3_column_int(pStmt, 1));
|
|
printf("Maximum value size: %8d\n", sqlite3_column_int(pStmt, 2));
|
|
}else{
|
|
printf("No rows\n");
|
|
}
|
|
sqlite3_finalize(pStmt);
|
|
zSql = sqlite3_mprintf("PRAGMA page_size");
|
|
rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
|
|
if( rc ) fatalError("cannot prepare SQL [%s]: %s", zSql, sqlite3_errmsg(db));
|
|
sqlite3_free(zSql);
|
|
if( sqlite3_step(pStmt)==SQLITE_ROW ){
|
|
printf("Page-size: %8d\n", sqlite3_column_int(pStmt, 0));
|
|
}
|
|
sqlite3_finalize(pStmt);
|
|
zSql = sqlite3_mprintf("PRAGMA page_count");
|
|
rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
|
|
if( rc ) fatalError("cannot prepare SQL [%s]: %s", zSql, sqlite3_errmsg(db));
|
|
sqlite3_free(zSql);
|
|
if( sqlite3_step(pStmt)==SQLITE_ROW ){
|
|
printf("Page-count: %8d\n", sqlite3_column_int(pStmt, 0));
|
|
}
|
|
sqlite3_finalize(pStmt);
|
|
zSql = sqlite3_mprintf("PRAGMA freelist_count");
|
|
rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
|
|
if( rc ) fatalError("cannot prepare SQL [%s]: %s", zSql, sqlite3_errmsg(db));
|
|
sqlite3_free(zSql);
|
|
if( sqlite3_step(pStmt)==SQLITE_ROW ){
|
|
printf("Freelist-count: %8d\n", sqlite3_column_int(pStmt, 0));
|
|
}
|
|
sqlite3_finalize(pStmt);
|
|
rc = sqlite3_prepare_v2(db, "PRAGMA integrity_check(10)", -1, &pStmt, 0);
|
|
if( rc ) fatalError("cannot prepare integrity check: %s", sqlite3_errmsg(db));
|
|
while( sqlite3_step(pStmt)==SQLITE_ROW ){
|
|
printf("Integrity-check: %s\n", sqlite3_column_text(pStmt, 0));
|
|
}
|
|
sqlite3_finalize(pStmt);
|
|
sqlite3_close(db);
|
|
return 0;
|
|
}
|
|
|
|
/*
|
|
** remember(V,PTR)
|
|
**
|
|
** Return the integer value V. Also save the value of V in a
|
|
** C-language variable whose address is PTR.
|
|
*/
|
|
static void rememberFunc(
|
|
sqlite3_context *pCtx,
|
|
int argc,
|
|
sqlite3_value **argv
|
|
){
|
|
sqlite3_int64 v;
|
|
sqlite3_int64 ptr;
|
|
assert( argc==2 );
|
|
v = sqlite3_value_int64(argv[0]);
|
|
ptr = sqlite3_value_int64(argv[1]);
|
|
*(sqlite3_int64*)SQLITE_INT_TO_PTR(ptr) = v;
|
|
sqlite3_result_int64(pCtx, v);
|
|
}
|
|
|
|
/*
|
|
** Make sure a directory named zDir exists.
|
|
*/
|
|
static void kvtest_mkdir(const char *zDir){
|
|
#if defined(_WIN32)
|
|
(void)mkdir(zDir);
|
|
#else
|
|
(void)mkdir(zDir, 0755);
|
|
#endif
|
|
}
|
|
|
|
/*
|
|
** Export the kv table to individual files in the filesystem
|
|
*/
|
|
static int exportMain(int argc, char **argv){
|
|
char *zDb;
|
|
char *zDir;
|
|
sqlite3 *db;
|
|
sqlite3_stmt *pStmt;
|
|
int rc;
|
|
int ePathType;
|
|
int nFN;
|
|
char *zFN;
|
|
char *zTail;
|
|
size_t nWrote;
|
|
int i;
|
|
|
|
assert( strcmp(argv[1],"export")==0 );
|
|
assert( argc>=3 );
|
|
if( argc<4 ) fatalError("Usage: kvtest export DATABASE DIRECTORY [OPTIONS]");
|
|
zDb = argv[2];
|
|
zDir = argv[3];
|
|
kvtest_mkdir(zDir);
|
|
for(i=4; i<argc; i++){
|
|
const char *z = argv[i];
|
|
if( z[0]=='-' && z[1]=='-' ) z++;
|
|
if( strcmp(z,"-tree")==0 ){
|
|
zFN = sqlite3_mprintf("%s/00", zDir);
|
|
kvtest_mkdir(zFN);
|
|
sqlite3_free(zFN);
|
|
continue;
|
|
}
|
|
fatalError("unknown argument: \"%s\"\n", argv[i]);
|
|
}
|
|
ePathType = pathType(zDir);
|
|
if( ePathType!=PATH_DIR && ePathType!=PATH_TREE ){
|
|
fatalError("object \"%s\" is not a directory", zDir);
|
|
}
|
|
rc = sqlite3_open(zDb, &db);
|
|
if( rc ){
|
|
fatalError("cannot open database \"%s\": %s", zDb, sqlite3_errmsg(db));
|
|
}
|
|
rc = sqlite3_prepare_v2(db, "SELECT k, v FROM kv ORDER BY k", -1, &pStmt, 0);
|
|
if( rc ){
|
|
fatalError("prepare_v2 failed: %s\n", sqlite3_errmsg(db));
|
|
}
|
|
nFN = (int)strlen(zDir);
|
|
zFN = sqlite3_mprintf("%s/00/00/00.extra---------------------", zDir);
|
|
if( zFN==0 ){
|
|
fatalError("malloc failed\n");
|
|
}
|
|
zTail = zFN + nFN + 1;
|
|
while( sqlite3_step(pStmt)==SQLITE_ROW ){
|
|
int iKey = sqlite3_column_int(pStmt, 0);
|
|
sqlite3_int64 nData = sqlite3_column_bytes(pStmt, 1);
|
|
const void *pData = sqlite3_column_blob(pStmt, 1);
|
|
FILE *out;
|
|
if( ePathType==PATH_DIR ){
|
|
sqlite3_snprintf(20, zTail, "%06d", iKey);
|
|
}else{
|
|
sqlite3_snprintf(20, zTail, "%02d", iKey/10000);
|
|
kvtest_mkdir(zFN);
|
|
sqlite3_snprintf(20, zTail, "%02d/%02d", iKey/10000, (iKey/100)%100);
|
|
kvtest_mkdir(zFN);
|
|
sqlite3_snprintf(20, zTail, "%02d/%02d/%02d",
|
|
iKey/10000, (iKey/100)%100, iKey%100);
|
|
}
|
|
out = fopen(zFN, "wb");
|
|
nWrote = fwrite(pData, 1, (size_t)nData, out);
|
|
fclose(out);
|
|
printf("\r%s ", zTail); fflush(stdout);
|
|
if( nWrote!=(size_t)nData ){
|
|
fatalError("Wrote only %d of %d bytes to %s\n",
|
|
(int)nWrote, nData, zFN);
|
|
}
|
|
}
|
|
sqlite3_finalize(pStmt);
|
|
sqlite3_close(db);
|
|
sqlite3_free(zFN);
|
|
printf("\n");
|
|
return 0;
|
|
}
|
|
|
|
/*
|
|
** Read the content of file zName into memory obtained from sqlite3_malloc64()
|
|
** and return a pointer to the buffer. The caller is responsible for freeing
|
|
** the memory.
|
|
**
|
|
** If parameter pnByte is not NULL, (*pnByte) is set to the number of bytes
|
|
** read.
|
|
**
|
|
** For convenience, a nul-terminator byte is always appended to the data read
|
|
** from the file before the buffer is returned. This byte is not included in
|
|
** the final value of (*pnByte), if applicable.
|
|
**
|
|
** NULL is returned if any error is encountered. The final value of *pnByte
|
|
** is undefined in this case.
|
|
*/
|
|
static unsigned char *readFile(const char *zName, sqlite3_int64 *pnByte){
|
|
FILE *in; /* FILE from which to read content of zName */
|
|
sqlite3_int64 nIn; /* Size of zName in bytes */
|
|
size_t nRead; /* Number of bytes actually read */
|
|
unsigned char *pBuf; /* Content read from disk */
|
|
|
|
nIn = fileSize(zName);
|
|
if( nIn<0 ) return 0;
|
|
in = fopen(zName, "rb");
|
|
if( in==0 ) return 0;
|
|
pBuf = sqlite3_malloc64( nIn );
|
|
if( pBuf==0 ) return 0;
|
|
nRead = fread(pBuf, (size_t)nIn, 1, in);
|
|
fclose(in);
|
|
if( nRead!=1 ){
|
|
sqlite3_free(pBuf);
|
|
return 0;
|
|
}
|
|
if( pnByte ) *pnByte = nIn;
|
|
return pBuf;
|
|
}
|
|
|
|
/*
|
|
** Overwrite a file with randomness. Do not change the size of the
|
|
** file.
|
|
*/
|
|
static void updateFile(const char *zName, sqlite3_int64 *pnByte, int doFsync){
|
|
FILE *out; /* FILE from which to read content of zName */
|
|
sqlite3_int64 sz; /* Size of zName in bytes */
|
|
size_t nWritten; /* Number of bytes actually read */
|
|
unsigned char *pBuf; /* Content to store on disk */
|
|
const char *zMode = "wb"; /* Mode for fopen() */
|
|
|
|
sz = fileSize(zName);
|
|
if( sz<0 ){
|
|
fatalError("No such file: \"%s\"", zName);
|
|
}
|
|
*pnByte = sz;
|
|
if( sz==0 ) return;
|
|
pBuf = sqlite3_malloc64( sz );
|
|
if( pBuf==0 ){
|
|
fatalError("Cannot allocate %lld bytes\n", sz);
|
|
}
|
|
sqlite3_randomness((int)sz, pBuf);
|
|
#if defined(_WIN32)
|
|
if( doFsync ) zMode = "wbc";
|
|
#endif
|
|
out = fopen(zName, zMode);
|
|
if( out==0 ){
|
|
fatalError("Cannot open \"%s\" for writing\n", zName);
|
|
}
|
|
nWritten = fwrite(pBuf, 1, (size_t)sz, out);
|
|
if( doFsync ){
|
|
#if defined(_WIN32)
|
|
fflush(out);
|
|
#else
|
|
fsync(fileno(out));
|
|
#endif
|
|
}
|
|
fclose(out);
|
|
if( nWritten!=(size_t)sz ){
|
|
fatalError("Wrote only %d of %d bytes to \"%s\"\n",
|
|
(int)nWritten, (int)sz, zName);
|
|
}
|
|
sqlite3_free(pBuf);
|
|
}
|
|
|
|
/*
|
|
** Return the current time in milliseconds since the beginning of
|
|
** the Julian epoch.
|
|
*/
|
|
static sqlite3_int64 timeOfDay(void){
|
|
static sqlite3_vfs *clockVfs = 0;
|
|
sqlite3_int64 t;
|
|
if( clockVfs==0 ) clockVfs = sqlite3_vfs_find(0);
|
|
if( clockVfs->iVersion>=2 && clockVfs->xCurrentTimeInt64!=0 ){
|
|
clockVfs->xCurrentTimeInt64(clockVfs, &t);
|
|
}else{
|
|
double r;
|
|
clockVfs->xCurrentTime(clockVfs, &r);
|
|
t = (sqlite3_int64)(r*86400000.0);
|
|
}
|
|
return t;
|
|
}
|
|
|
|
#ifdef __linux__
|
|
/*
|
|
** Attempt to display I/O stats on Linux using /proc/PID/io
|
|
*/
|
|
static void displayLinuxIoStats(FILE *out){
|
|
FILE *in;
|
|
char z[200];
|
|
sqlite3_snprintf(sizeof(z), z, "/proc/%d/io", getpid());
|
|
in = fopen(z, "rb");
|
|
if( in==0 ) return;
|
|
while( fgets(z, sizeof(z), in)!=0 ){
|
|
static const struct {
|
|
const char *zPattern;
|
|
const char *zDesc;
|
|
} aTrans[] = {
|
|
{ "rchar: ", "Bytes received by read():" },
|
|
{ "wchar: ", "Bytes sent to write():" },
|
|
{ "syscr: ", "Read() system calls:" },
|
|
{ "syscw: ", "Write() system calls:" },
|
|
{ "read_bytes: ", "Bytes read from storage:" },
|
|
{ "write_bytes: ", "Bytes written to storage:" },
|
|
{ "cancelled_write_bytes: ", "Cancelled write bytes:" },
|
|
};
|
|
int i;
|
|
for(i=0; i<sizeof(aTrans)/sizeof(aTrans[0]); i++){
|
|
int n = (int)strlen(aTrans[i].zPattern);
|
|
if( strncmp(aTrans[i].zPattern, z, n)==0 ){
|
|
fprintf(out, "%-36s %s", aTrans[i].zDesc, &z[n]);
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
fclose(in);
|
|
}
|
|
#endif
|
|
|
|
/*
|
|
** Display memory stats.
|
|
*/
|
|
static int display_stats(
|
|
sqlite3 *db, /* Database to query */
|
|
int bReset /* True to reset SQLite stats */
|
|
){
|
|
int iCur;
|
|
int iHiwtr;
|
|
FILE *out = stdout;
|
|
|
|
fprintf(out, "\n");
|
|
|
|
iHiwtr = iCur = -1;
|
|
sqlite3_status(SQLITE_STATUS_MEMORY_USED, &iCur, &iHiwtr, bReset);
|
|
fprintf(out,
|
|
"Memory Used: %d (max %d) bytes\n",
|
|
iCur, iHiwtr);
|
|
iHiwtr = iCur = -1;
|
|
sqlite3_status(SQLITE_STATUS_MALLOC_COUNT, &iCur, &iHiwtr, bReset);
|
|
fprintf(out, "Number of Outstanding Allocations: %d (max %d)\n",
|
|
iCur, iHiwtr);
|
|
iHiwtr = iCur = -1;
|
|
sqlite3_status(SQLITE_STATUS_PAGECACHE_USED, &iCur, &iHiwtr, bReset);
|
|
fprintf(out,
|
|
"Number of Pcache Pages Used: %d (max %d) pages\n",
|
|
iCur, iHiwtr);
|
|
iHiwtr = iCur = -1;
|
|
sqlite3_status(SQLITE_STATUS_PAGECACHE_OVERFLOW, &iCur, &iHiwtr, bReset);
|
|
fprintf(out,
|
|
"Number of Pcache Overflow Bytes: %d (max %d) bytes\n",
|
|
iCur, iHiwtr);
|
|
iHiwtr = iCur = -1;
|
|
sqlite3_status(SQLITE_STATUS_MALLOC_SIZE, &iCur, &iHiwtr, bReset);
|
|
fprintf(out, "Largest Allocation: %d bytes\n",
|
|
iHiwtr);
|
|
iHiwtr = iCur = -1;
|
|
sqlite3_status(SQLITE_STATUS_PAGECACHE_SIZE, &iCur, &iHiwtr, bReset);
|
|
fprintf(out, "Largest Pcache Allocation: %d bytes\n",
|
|
iHiwtr);
|
|
|
|
iHiwtr = iCur = -1;
|
|
sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_USED, &iCur, &iHiwtr, bReset);
|
|
fprintf(out, "Pager Heap Usage: %d bytes\n",
|
|
iCur);
|
|
iHiwtr = iCur = -1;
|
|
sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_HIT, &iCur, &iHiwtr, 1);
|
|
fprintf(out, "Page cache hits: %d\n", iCur);
|
|
iHiwtr = iCur = -1;
|
|
sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_MISS, &iCur, &iHiwtr, 1);
|
|
fprintf(out, "Page cache misses: %d\n", iCur);
|
|
iHiwtr = iCur = -1;
|
|
sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_WRITE, &iCur, &iHiwtr, 1);
|
|
fprintf(out, "Page cache writes: %d\n", iCur);
|
|
iHiwtr = iCur = -1;
|
|
|
|
#ifdef __linux__
|
|
displayLinuxIoStats(out);
|
|
#endif
|
|
|
|
return 0;
|
|
}
|
|
|
|
/* Blob access order */
|
|
#define ORDER_ASC 1
|
|
#define ORDER_DESC 2
|
|
#define ORDER_RANDOM 3
|
|
|
|
|
|
/*
|
|
** Run a performance test
|
|
*/
|
|
static int runMain(int argc, char **argv){
|
|
int eType; /* Is zDb a database or a directory? */
|
|
char *zDb; /* Database or directory name */
|
|
int i; /* Loop counter */
|
|
int rc; /* Return code from SQLite calls */
|
|
int nCount = 1000; /* Number of blob fetch operations */
|
|
int nExtra = 0; /* Extra cycles */
|
|
int iKey = 1; /* Next blob key */
|
|
int iMax = 0; /* Largest allowed key */
|
|
int iPagesize = 0; /* Database page size */
|
|
int iCache = 1000; /* Database cache size in kibibytes */
|
|
int bBlobApi = 0; /* Use the incremental blob I/O API */
|
|
int bStats = 0; /* Print stats before exiting */
|
|
int eOrder = ORDER_ASC; /* Access order */
|
|
int isUpdateTest = 0; /* Do in-place updates rather than reads */
|
|
int doIntegrityCk = 0; /* Run PRAGMA integrity_check after the test */
|
|
int noSync = 0; /* Disable synchronous mode */
|
|
int doFsync = 0; /* Update disk files synchronously */
|
|
int doMultiTrans = 0; /* Each operation in its own transaction */
|
|
int noCheckpoint = 0; /* Omit the checkpoint in WAL mode */
|
|
sqlite3 *db = 0; /* Database connection */
|
|
sqlite3_stmt *pStmt = 0; /* Prepared statement for SQL access */
|
|
sqlite3_blob *pBlob = 0; /* Handle for incremental Blob I/O */
|
|
sqlite3_int64 tmStart; /* Start time */
|
|
sqlite3_int64 tmElapsed; /* Elapsed time */
|
|
int mmapSize = 0; /* --mmap N argument */
|
|
sqlite3_int64 nData = 0; /* Bytes of data */
|
|
sqlite3_int64 nTotal = 0; /* Total data read */
|
|
unsigned char *pData = 0; /* Content of the blob */
|
|
sqlite3_int64 nAlloc = 0; /* Space allocated for pData[] */
|
|
const char *zJMode = 0; /* Journal mode */
|
|
|
|
|
|
assert( strcmp(argv[1],"run")==0 );
|
|
assert( argc>=3 );
|
|
zDb = argv[2];
|
|
eType = pathType(zDb);
|
|
if( eType==PATH_OTHER ) fatalError("unknown object type: \"%s\"", zDb);
|
|
if( eType==PATH_NEXIST ) fatalError("object does not exist: \"%s\"", zDb);
|
|
for(i=3; i<argc; i++){
|
|
char *z = argv[i];
|
|
if( z[0]!='-' ) fatalError("unknown argument: \"%s\"", z);
|
|
if( z[1]=='-' ) z++;
|
|
if( strcmp(z, "-asc")==0 ){
|
|
eOrder = ORDER_ASC;
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-blob-api")==0 ){
|
|
bBlobApi = 1;
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-cache-size")==0 ){
|
|
if( i==argc-1 ) fatalError("missing argument on \"%s\"", argv[i]);
|
|
iCache = integerValue(argv[++i]);
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-count")==0 ){
|
|
if( i==argc-1 ) fatalError("missing argument on \"%s\"", argv[i]);
|
|
nCount = integerValue(argv[++i]);
|
|
if( nCount<1 ) fatalError("the --count must be positive");
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-desc")==0 ){
|
|
eOrder = ORDER_DESC;
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-fsync")==0 ){
|
|
doFsync = 1;
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-integrity-check")==0 ){
|
|
doIntegrityCk = 1;
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-jmode")==0 ){
|
|
if( i==argc-1 ) fatalError("missing argument on \"%s\"", argv[i]);
|
|
zJMode = argv[++i];
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-mmap")==0 ){
|
|
if( i==argc-1 ) fatalError("missing argument on \"%s\"", argv[i]);
|
|
mmapSize = integerValue(argv[++i]);
|
|
if( nCount<0 ) fatalError("the --mmap must be non-negative");
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-max-id")==0 ){
|
|
if( i==argc-1 ) fatalError("missing argument on \"%s\"", argv[i]);
|
|
iMax = integerValue(argv[++i]);
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-multitrans")==0 ){
|
|
doMultiTrans = 1;
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-nocheckpoint")==0 ){
|
|
noCheckpoint = 1;
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-nosync")==0 ){
|
|
noSync = 1;
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-random")==0 ){
|
|
eOrder = ORDER_RANDOM;
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-start")==0 ){
|
|
if( i==argc-1 ) fatalError("missing argument on \"%s\"", argv[i]);
|
|
iKey = integerValue(argv[++i]);
|
|
if( iKey<1 ) fatalError("the --start must be positive");
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-stats")==0 ){
|
|
bStats = 1;
|
|
continue;
|
|
}
|
|
if( strcmp(z, "-update")==0 ){
|
|
isUpdateTest = 1;
|
|
continue;
|
|
}
|
|
fatalError("unknown option: \"%s\"", argv[i]);
|
|
}
|
|
if( eType==PATH_DB ){
|
|
/* Recover any prior crashes prior to starting the timer */
|
|
sqlite3_open(zDb, &db);
|
|
sqlite3_exec(db, "SELECT rowid FROM sqlite_schema LIMIT 1", 0, 0, 0);
|
|
sqlite3_close(db);
|
|
db = 0;
|
|
}
|
|
tmStart = timeOfDay();
|
|
if( eType==PATH_DB ){
|
|
char *zSql;
|
|
rc = sqlite3_open(zDb, &db);
|
|
if( rc ){
|
|
fatalError("cannot open database \"%s\": %s", zDb, sqlite3_errmsg(db));
|
|
}
|
|
zSql = sqlite3_mprintf("PRAGMA mmap_size=%d", mmapSize);
|
|
sqlite3_exec(db, zSql, 0, 0, 0);
|
|
sqlite3_free(zSql);
|
|
zSql = sqlite3_mprintf("PRAGMA cache_size=%d", iCache);
|
|
sqlite3_exec(db, zSql, 0, 0, 0);
|
|
sqlite3_free(zSql);
|
|
if( noSync ){
|
|
sqlite3_exec(db, "PRAGMA synchronous=OFF", 0, 0, 0);
|
|
}
|
|
pStmt = 0;
|
|
sqlite3_prepare_v2(db, "PRAGMA page_size", -1, &pStmt, 0);
|
|
if( sqlite3_step(pStmt)==SQLITE_ROW ){
|
|
iPagesize = sqlite3_column_int(pStmt, 0);
|
|
}
|
|
sqlite3_finalize(pStmt);
|
|
sqlite3_prepare_v2(db, "PRAGMA cache_size", -1, &pStmt, 0);
|
|
if( sqlite3_step(pStmt)==SQLITE_ROW ){
|
|
iCache = sqlite3_column_int(pStmt, 0);
|
|
}else{
|
|
iCache = 0;
|
|
}
|
|
sqlite3_finalize(pStmt);
|
|
pStmt = 0;
|
|
if( zJMode ){
|
|
zSql = sqlite3_mprintf("PRAGMA journal_mode=%Q", zJMode);
|
|
sqlite3_exec(db, zSql, 0, 0, 0);
|
|
sqlite3_free(zSql);
|
|
if( noCheckpoint ){
|
|
sqlite3_exec(db, "PRAGMA wal_autocheckpoint=0", 0, 0, 0);
|
|
}
|
|
}
|
|
sqlite3_prepare_v2(db, "PRAGMA journal_mode", -1, &pStmt, 0);
|
|
if( sqlite3_step(pStmt)==SQLITE_ROW ){
|
|
zJMode = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 0));
|
|
}else{
|
|
zJMode = "???";
|
|
}
|
|
sqlite3_finalize(pStmt);
|
|
if( iMax<=0 ){
|
|
sqlite3_prepare_v2(db, "SELECT max(k) FROM kv", -1, &pStmt, 0);
|
|
if( sqlite3_step(pStmt)==SQLITE_ROW ){
|
|
iMax = sqlite3_column_int(pStmt, 0);
|
|
}
|
|
sqlite3_finalize(pStmt);
|
|
}
|
|
pStmt = 0;
|
|
if( !doMultiTrans ) sqlite3_exec(db, "BEGIN", 0, 0, 0);
|
|
}
|
|
if( iMax<=0 ) iMax = 1000;
|
|
for(i=0; i<nCount; i++){
|
|
if( eType==PATH_DIR || eType==PATH_TREE ){
|
|
/* CASE 1: Reading or writing blobs out of separate files */
|
|
char *zKey;
|
|
if( eType==PATH_DIR ){
|
|
zKey = sqlite3_mprintf("%s/%06d", zDb, iKey);
|
|
}else{
|
|
zKey = sqlite3_mprintf("%s/%02d/%02d/%02d", zDb, iKey/10000,
|
|
(iKey/100)%100, iKey%100);
|
|
}
|
|
nData = 0;
|
|
if( isUpdateTest ){
|
|
updateFile(zKey, &nData, doFsync);
|
|
}else{
|
|
pData = readFile(zKey, &nData);
|
|
sqlite3_free(pData);
|
|
}
|
|
sqlite3_free(zKey);
|
|
}else if( bBlobApi ){
|
|
/* CASE 2: Reading from database using the incremental BLOB I/O API */
|
|
if( pBlob==0 ){
|
|
rc = sqlite3_blob_open(db, "main", "kv", "v", iKey,
|
|
isUpdateTest, &pBlob);
|
|
if( rc ){
|
|
fatalError("could not open sqlite3_blob handle: %s",
|
|
sqlite3_errmsg(db));
|
|
}
|
|
}else{
|
|
rc = sqlite3_blob_reopen(pBlob, iKey);
|
|
}
|
|
if( rc==SQLITE_OK ){
|
|
nData = sqlite3_blob_bytes(pBlob);
|
|
if( nAlloc<nData+1 ){
|
|
nAlloc = nData+100;
|
|
pData = sqlite3_realloc64(pData, nAlloc);
|
|
}
|
|
if( pData==0 ) fatalError("cannot allocate %d bytes", nData+1);
|
|
if( isUpdateTest ){
|
|
sqlite3_randomness((int)nData, pData);
|
|
rc = sqlite3_blob_write(pBlob, pData, (int)nData, 0);
|
|
if( rc!=SQLITE_OK ){
|
|
fatalError("could not write the blob at %d: %s", iKey,
|
|
sqlite3_errmsg(db));
|
|
}
|
|
}else{
|
|
rc = sqlite3_blob_read(pBlob, pData, (int)nData, 0);
|
|
if( rc!=SQLITE_OK ){
|
|
fatalError("could not read the blob at %d: %s", iKey,
|
|
sqlite3_errmsg(db));
|
|
}
|
|
}
|
|
}
|
|
}else{
|
|
/* CASE 3: Reading from database using SQL */
|
|
if( pStmt==0 ){
|
|
if( isUpdateTest ){
|
|
sqlite3_create_function(db, "remember", 2, SQLITE_UTF8, 0,
|
|
rememberFunc, 0, 0);
|
|
|
|
rc = sqlite3_prepare_v2(db,
|
|
"UPDATE kv SET v=randomblob(remember(length(v),?2))"
|
|
" WHERE k=?1", -1, &pStmt, 0);
|
|
sqlite3_bind_int64(pStmt, 2, SQLITE_PTR_TO_INT(&nData));
|
|
}else{
|
|
rc = sqlite3_prepare_v2(db,
|
|
"SELECT v FROM kv WHERE k=?1", -1, &pStmt, 0);
|
|
}
|
|
if( rc ){
|
|
fatalError("cannot prepare query: %s", sqlite3_errmsg(db));
|
|
}
|
|
}else{
|
|
sqlite3_reset(pStmt);
|
|
}
|
|
sqlite3_bind_int(pStmt, 1, iKey);
|
|
nData = 0;
|
|
rc = sqlite3_step(pStmt);
|
|
if( rc==SQLITE_ROW ){
|
|
nData = sqlite3_column_bytes(pStmt, 0);
|
|
pData = (unsigned char*)sqlite3_column_blob(pStmt, 0);
|
|
}
|
|
}
|
|
if( eOrder==ORDER_ASC ){
|
|
iKey++;
|
|
if( iKey>iMax ) iKey = 1;
|
|
}else if( eOrder==ORDER_DESC ){
|
|
iKey--;
|
|
if( iKey<=0 ) iKey = iMax;
|
|
}else{
|
|
iKey = (randInt()%iMax)+1;
|
|
}
|
|
nTotal += nData;
|
|
if( nData==0 ){ nCount++; nExtra++; }
|
|
}
|
|
if( nAlloc ) sqlite3_free(pData);
|
|
if( pStmt ) sqlite3_finalize(pStmt);
|
|
if( pBlob ) sqlite3_blob_close(pBlob);
|
|
if( bStats ){
|
|
display_stats(db, 0);
|
|
}
|
|
if( db ){
|
|
if( !doMultiTrans ) sqlite3_exec(db, "COMMIT", 0, 0, 0);
|
|
if( !noCheckpoint ){
|
|
sqlite3_close(db);
|
|
db = 0;
|
|
}
|
|
}
|
|
tmElapsed = timeOfDay() - tmStart;
|
|
if( db && noCheckpoint ){
|
|
sqlite3_close(db);
|
|
db = 0;
|
|
}
|
|
if( nExtra ){
|
|
printf("%d cycles due to %d misses\n", nCount, nExtra);
|
|
}
|
|
if( eType==PATH_DB ){
|
|
printf("SQLite version: %s\n", sqlite3_libversion());
|
|
if( doIntegrityCk ){
|
|
sqlite3_open(zDb, &db);
|
|
sqlite3_prepare_v2(db, "PRAGMA integrity_check", -1, &pStmt, 0);
|
|
while( sqlite3_step(pStmt)==SQLITE_ROW ){
|
|
printf("integrity-check: %s\n", sqlite3_column_text(pStmt, 0));
|
|
}
|
|
sqlite3_finalize(pStmt);
|
|
sqlite3_close(db);
|
|
db = 0;
|
|
}
|
|
}
|
|
printf("--count %d --max-id %d", nCount-nExtra, iMax);
|
|
switch( eOrder ){
|
|
case ORDER_RANDOM: printf(" --random\n"); break;
|
|
case ORDER_DESC: printf(" --desc\n"); break;
|
|
default: printf(" --asc\n"); break;
|
|
}
|
|
if( eType==PATH_DB ){
|
|
printf("--cache-size %d --jmode %s\n", iCache, zJMode);
|
|
printf("--mmap %d%s\n", mmapSize, bBlobApi ? " --blob-api" : "");
|
|
if( noSync ) printf("--nosync\n");
|
|
}
|
|
if( iPagesize ) printf("Database page size: %d\n", iPagesize);
|
|
printf("Total elapsed time: %.3f\n", tmElapsed/1000.0);
|
|
if( isUpdateTest ){
|
|
printf("Microseconds per BLOB write: %.3f\n", tmElapsed*1000.0/nCount);
|
|
printf("Content write rate: %.1f MB/s\n", nTotal/(1000.0*tmElapsed));
|
|
}else{
|
|
printf("Microseconds per BLOB read: %.3f\n", tmElapsed*1000.0/nCount);
|
|
printf("Content read rate: %.1f MB/s\n", nTotal/(1000.0*tmElapsed));
|
|
}
|
|
return 0;
|
|
}
|
|
|
|
|
|
int main(int argc, char **argv){
|
|
if( argc<3 ) showHelp();
|
|
if( strcmp(argv[1],"init")==0 ){
|
|
return initMain(argc, argv);
|
|
}
|
|
if( strcmp(argv[1],"export")==0 ){
|
|
return exportMain(argc, argv);
|
|
}
|
|
if( strcmp(argv[1],"run")==0 ){
|
|
return runMain(argc, argv);
|
|
}
|
|
if( strcmp(argv[1],"stat")==0 ){
|
|
return statMain(argc, argv);
|
|
}
|
|
showHelp();
|
|
return 0;
|
|
}
|