Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add an elapsed-time output for faststat1.c. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | est_count_pragma |
Files: | files | file ages | folders |
SHA1: |
7116795134922b7dc6c527365faadf0b |
User & Date: | drh 2016-10-26 12:58:31.518 |
Context
2016-11-30
| ||
16:39 | Merge all the latest changes from trunk. (check-in: 7ca58a07d3 user: drh tags: est_count_pragma) | |
2016-10-26
| ||
12:58 | Add an elapsed-time output for faststat1.c. (check-in: 7116795134 user: drh tags: est_count_pragma) | |
2016-10-25
| ||
19:39 | Simplifications to faststat1.c. Fix a bug in sqlite3MovetoProportional() for very large b-trees. (check-in: f7f78147c5 user: drh tags: est_count_pragma) | |
Changes
Changes to tool/faststat1.c.
︙ | ︙ | |||
65 66 67 68 69 70 71 72 73 74 75 76 77 78 | fprintf(stderr, "%s: ", g.zArgv0); va_start(ap, zFormat); vfprintf(stderr, zFormat, ap); va_end(ap); fprintf(stderr, "\n"); exit(1); } /* ** Prepare a new SQL statement. Print an error and abort if anything ** goes wrong. */ static sqlite3_stmt *db_vprepare(const char *zFormat, va_list ap){ char *zSql; | > > > > > > > > > > | 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 | fprintf(stderr, "%s: ", g.zArgv0); va_start(ap, zFormat); vfprintf(stderr, zFormat, ap); va_end(ap); fprintf(stderr, "\n"); exit(1); } /* ** Return the current time in milliseconds since the julian epoch. */ static sqlite3_int64 currentTime(void){ sqlite3_vfs *pVfs = sqlite3_vfs_find(0); sqlite3_int64 x = 0; (void)pVfs->xCurrentTimeInt64(pVfs, &x); return x; } /* ** Prepare a new SQL statement. Print an error and abort if anything ** goes wrong. */ static sqlite3_stmt *db_vprepare(const char *zFormat, va_list ap){ char *zSql; |
︙ | ︙ | |||
284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 | int main(int argc, char **argv){ const char *zDb = 0; int i; int rc; char *zErrMsg = 0; sqlite3_stmt *pStmt; g.zArgv0 = argv[0]; sqlite3_config(SQLITE_CONFIG_SINGLETHREAD); for(i=1; i<argc; i++){ const char *z = argv[i]; if( z[0]=='-' ){ z++; if( z[0]=='-' ) z++; if( strcmp(z,"debug")==0 ){ if( i==argc-1 ) cmdlineError("missing argument to %s", argv[i]); | > > | 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 | int main(int argc, char **argv){ const char *zDb = 0; int i; int rc; char *zErrMsg = 0; sqlite3_stmt *pStmt; sqlite3_int64 iStart, iTotal; g.zArgv0 = argv[0]; sqlite3_config(SQLITE_CONFIG_SINGLETHREAD); iStart = currentTime(); for(i=1; i<argc; i++){ const char *z = argv[i]; if( z[0]=='-' ){ z++; if( z[0]=='-' ) z++; if( strcmp(z,"debug")==0 ){ if( i==argc-1 ) cmdlineError("missing argument to %s", argv[i]); |
︙ | ︙ | |||
332 333 334 335 336 337 338 339 340 | while( sqlite3_step(pStmt)==SQLITE_ROW ){ const char *zName = (const char*)sqlite3_column_text(pStmt, 0); analyzeTable(zName); } sqlite3_finalize(pStmt); printf("ANALYZE sqlite_master;\n"); sqlite3_close(g.db); return 0; } | > > | 344 345 346 347 348 349 350 351 352 353 354 | while( sqlite3_step(pStmt)==SQLITE_ROW ){ const char *zName = (const char*)sqlite3_column_text(pStmt, 0); analyzeTable(zName); } sqlite3_finalize(pStmt); printf("ANALYZE sqlite_master;\n"); sqlite3_close(g.db); iTotal = currentTime() - iStart; printf("-- elapsed time: %lld.%03lld seconds\n", iTotal/1000, iTotal%1000); return 0; } |