/ All files named "test/speedtest1.c"
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/speedtest1.c

2020-12-02
00:20
[5e5b805f] part of check-in [55fa22bd] Slightly faster tokenization of non-keyword identifiers. (check-in: [55fa22bd] user: drh branch: trunk, size: 84616)
2020-11-05
14:50
[849dbcb0] part of check-in [c0a18565] Remove unused variable from speedtest1.c (check-in: [c0a18565] user: drh branch: trunk, size: 84616)
2020-10-15
17:59
[6f74bbfd] part of check-in [ed3bb818] Minor fixes to the cksumvfs documentation in the header comment of the source file. Enhance speedtest1.c so that it can more easily do performance comparisons of cksumvfs. (check-in: [ed3bb818] user: drh branch: trunk, size: 84668)
2020-08-07
14:47
[ac0e6eba] part of check-in [4cffa9bb] Add the --checkpoint option to speedtest1. (check-in: [4cffa9bb] user: drh branch: trunk, size: 84096)
2020-07-29
16:18
[cfc794a6] part of check-in [a80ae2c9] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c9] user: drh branch: typos, size: 83741)
2020-06-26
17:56
[a8b5afe7] part of check-in [e12225d5] When computing the verification hash in speedtest1, do not include the value of floating point results (which can very in trailing bits depending on platform) but merely hash the fact that a floating point value was received. (check-in: [e12225d5] user: drh branch: trunk, size: 83740)
16:17
[01ae6222] part of check-in [d34b8ff5] Improvements to speedtest1.c for more consistent verification hashes. (check-in: [d34b8ff5] user: drh branch: trunk, size: 83785)
14:05
[18c3a29f] part of check-in [89a11120] Add --verify to speed-check.sh and add --memdb and --output to speedtest1.c. Other improvements to speedtest1.c. (check-in: [89a11120] user: drh branch: speedtest-hash, size: 83247)
2020-06-25
20:28
[62a22866] part of check-in [60d1e46c] Enhance the --verify option to speedtest1.c so that it computes and displays a hash of the result from all SQL queries, for verification purposes. (check-in: [60d1e46c] user: drh branch: speedtest-hash, size: 81610)
2020-06-23
20:03
[ea201573] part of check-in [780e8aaa] Enhance the --testset option on speedtest1 so that it can accept a comma-separated list of test modules to run in order. (check-in: [780e8aaa] user: drh branch: trunk, size: 78993)
2020-01-29
13:10
[d564e768] part of check-in [a9b2adc5] Add new memory barriers during initialization. (check-in: [a9b2adc5] user: drh branch: trunk, size: 77081)
2019-05-25
13:14
[f3bfe3c6] part of check-in [b84e7057] Add new cases to speedtest1 for measuring performance of binary to/from decimal conversions of floating point values. (check-in: [b84e7057] user: drh branch: trunk, size: 77058)
2018-05-24
16:18
[cc7e6b4a] part of check-in [95f2d62c] Addition cases for rtree preformance testing in speedtest1.c. Add the --nodiff option to the speed-check.sh script. (check-in: [95f2d62c] user: drh branch: trunk, size: 76675)
2018-04-03
20:44
[20cc4028] part of check-in [5a6fd9e0] Fix an error message in speedtest1.c and make the "trigger" testset sensitive to the --size parameter. (check-in: [5a6fd9e0] user: drh branch: trunk, size: 75221)
20:00
[3f174276] part of check-in [7b7fa5fa] Update speedtest1.c with new testset "trigger" based on the tests in speed4p.test. (check-in: [7b7fa5fa] user: dan branch: trunk, size: 75176)
2017-12-26
14:12
[a5faf4cb] part of check-in [b3c61051] Add options to speedtest1.c and speed-check.sh for testing performance of floating-point computatations. (check-in: [b3c61051] user: drh branch: mistake, size: 68673)
2017-10-04
17:05
[e44c5fcc] part of check-in [7c69f8f1] Update the speedtest1 program so that it prints the output of "PRAGMA compile_options" if the -stats option is specified. (check-in: [7c69f8f1] user: dan branch: trunk, size: 66476)
2017-08-28
15:51
[7a6ec22e] part of check-in [54b00024] Remove the rarely-used scratch memory allocator. This makes the code smaller, faster, and easier to maintain. In place of the scratch allocator, add the SQLITE_CONFIG_SMALL_MALLOC configuration option that provides a hint to SQLite that large memory allocations should be avoided. (check-in: [54b00024] user: drh branch: trunk, size: 66231)
2017-02-14
16:30
[7b1ab42b] part of check-in [e4731fd6] More realistic lengths of string values in speedtest1 with --testset orm. (check-in: [e4731fd6] user: drh branch: trunk, size: 67339)
15:58
[4f7a10a3] part of check-in [58b2f911] Fix a testcase number on the ORM testset of speedtest1. (check-in: [58b2f911] user: drh branch: trunk, size: 67332)
15:57
[89795b8e] part of check-in [1836adc1] Add the new "--testset orm" to the speedtest1 utility. (check-in: [1836adc1] user: drh branch: trunk, size: 67332)
2017-01-20
16:09
[02fe15bb] part of check-in [87b640c8] Get the "--testset rtree" option working on speedtest1. Add the --rtree, --lookaside, and --clang options to the speed-check.sh script. (check-in: [87b640c8] user: drh branch: trunk, size: 54313)
2016-12-31
18:37
[4e8ea616] part of check-in [52b99bcb] In speedtest1.c, make the "--lookaside 0 0" option completely disable lookaside. (check-in: [52b99bcb] user: drh branch: speedtest1, size: 54527)
14:33
[2feca857] part of check-in [8c28fde0] Minor #include change to speedtest1.c so that it will compile under MSVC. (check-in: [8c28fde0] user: drh branch: speedtest1, size: 54526)
2016-12-12
23:24
[0c92fd0d] part of check-in [1a636d5e] Add the --mmap option to the speedtest1 program and to the speed-check.sh script that is frequently used to run speedtest1. (check-in: [1a636d5e] user: drh branch: trunk, size: 54480)
2016-11-21
18:15
[dae4b22c] part of check-in [9979ba80] Enhance speedtest1.c so that is works on older versions of SQLite, before the introduction of the group_concat() aggregate function. (check-in: [9979ba80] user: drh branch: trunk, size: 54059)
2016-11-15
21:17
[2699cdb3] part of check-in [77aeb705] Add a needed #include to speedtest1.c. (check-in: [77aeb705] user: drh branch: trunk, size: 52283)
2016-11-09
01:07
[48d82e01] part of check-in [754ee844] Add a DISTINCT query to speedtest1.c. Also change INSERT OR REPLACE into just REPLACE. (check-in: [754ee844] user: drh branch: trunk, size: 52263)
2016-11-08
16:27
[cb433ff7] part of check-in [c2f84f63] Fix the speedtest1.c test program so that it gives closing "%" wildcards on LIKE searches. (check-in: [c2f84f63] user: drh branch: trunk, size: 52126)
00:30
[4b2538e9] part of check-in [b5733cae] Tweaks to speedtest1.c to better reflect mobile usage based on findings in the "Pocket Data" paper by Kennedy, Ajay, Challen, and Ziarek. (check-in: [b5733cae] user: drh branch: trunk, size: 52120)
2016-10-18
15:29
[ffb96750] part of check-in [2aa7a03b] Fix harmless uninitialized variable warnings in speedtest1.c. (check-in: [2aa7a03b] user: drh branch: trunk, size: 50052)
14:35
[0258bb62] part of check-in [6ca0e06b] Add the --repeat option to speedtest1.c and speed-check.sh. (check-in: [6ca0e06b] user: drh branch: trunk, size: 50037)
2016-09-21
23:58
[43b25ae8] part of check-in [7785b3a2] Fix speedtest1.c so that it works with SQLITE_OMIT_DEPRECATED. Add the --lean and --cachesize options to speed-check.sh. (check-in: [7785b3a2] user: drh branch: trunk, size: 49411)
2016-06-04
16:33
[28221f43] part of check-in [9583c0fb] Fix up speedtest1.c so that it will compile and run on SQLite versions prior to 3.6.18 (circa 2009-09-11). (check-in: [9583c0fb] user: drh branch: trunk, size: 49306)
2016-04-12
17:13
[4476f703] part of check-in [b65b69f6] Fix speedtest1 so that it automatically unlinks its test database prior to startup. (check-in: [b65b69f6] user: drh branch: trunk, size: 49216)
16:59
[870ea1f3] part of check-in [8053a6e2] Add the --temp option to the speedtest1.c performance test program. (check-in: [8053a6e2] user: drh branch: trunk, size: 49250)
2016-03-30
12:20
[21af8db2] part of check-in [e4bee561] Improvements to the performance testing program "speedtest1.c" and the shell script that invokes it. (check-in: [e4bee561] user: drh branch: trunk, size: 48619)
2016-02-27
19:19
[1478cb3f] part of check-in [f681d800] Tighter description of I/O stats in the shell. Show I/O stats on speedtest1.c. (check-in: [f681d800] user: drh branch: trunk, size: 48607)
2016-02-19
16:19
[947421c3] part of check-in [0cb728c1] Enhance speedtest1 to display the particular version of SQLite under test. (check-in: [0cb728c1] user: drh branch: trunk, size: 47327)
2015-10-29
13:48
[f8bf0421] part of check-in [34eb6911] Fix uses of ctype functions (ex: isspace()) on signed characters in test programs and in some obscure extensions. No changes to the core. (check-in: [34eb6911] user: drh branch: trunk, size: 47187)
2015-07-23
20:44
[85743986] part of check-in [017c5019] Change the name of the OTA extension to RBU: Resumable Bulk Update. (check-in: [017c5019] user: drh branch: trunk, size: 47093)
2015-07-06
18:54
[54f21199] part of check-in [aa7341c8] Enhance separate pcache1 to allocate a block of pages from heap on startup, if possible, for a 5.2% performance improvement. (check-in: [aa7341c8] user: drh branch: pcache-bulk-local, size: 47093)
2015-07-03
14:34
[2e8f367c] part of check-in [2b756722] New command-line options for speedtest1: --multithread, --nomemstat, --serialized, and --singlethread (check-in: [2b756722] user: drh branch: trunk, size: 46976)
2015-07-02
01:38
[a2834483] part of check-in [c9ddbd88] Add the --shrink-memory option to the speedtest1 test program. (check-in: [c9ddbd88] user: drh branch: trunk, size: 46349)
2015-06-18
15:26
[f42fd04a] part of check-in [9246eca5] Further #ifdef changes in speedtest1.c in order to support SQLite back to version 3.3.9 and perhaps even earlier. (check-in: [9246eca5] user: drh branch: trunk, size: 45836)
12:37
[613e7f60] part of check-in [f50dd154] Add #ifdefs to some features speedtest1.c so that it compiles with older versions of SQLite, going back to version 3.5.1. (check-in: [f50dd154] user: drh branch: trunk, size: 45700)
2015-03-05
16:21
[9f1b745c] part of check-in [46119e8d] Fix some problems with OTA and empty target databases, or target databases with the wrong set of tables. Also add SQLITE_FCNTL_VFSNAME support to the OTA VFS. (check-in: [46119e8d] user: dan branch: ota-update, size: 45529)
2015-02-03
19:20
[2b416dca] part of check-in [f30a057a] Fix a typo in the --help output for speedtest1. Fix a dependency error in the Makefile.in for speedtest1. (check-in: [f30a057a] user: drh branch: trunk, size: 45298)
2014-10-11
10:52
[e4e2aa37] part of check-in [5d29a033] Require the SQLITE_ENABLE_RTREE compile-time option in speedtest1.c in order to enable the R-Tree tests. (check-in: [5d29a033] user: drh branch: trunk, size: 45301)
2014-08-29
18:06
[83f6b331] part of check-in [2ab4b5ad] Fix the speedtest1.c test program to set the worker thread count using the threads pragma. (check-in: [2ab4b5ad] user: drh branch: threads, size: 45004)
2014-05-02
18:05
[f452891e] part of check-in [d9549de3] Merge orderby-planning with this branch. (check-in: [d9549de3] user: dan branch: threads, size: 45080)
2014-04-18
13:57
[bd150a4c] part of check-in [5fce40c4] Add to speedtest1.c the --threads option for setting the SQLITE_CONFIG_WORKER_THREADS configuration. (check-in: [5fce40c4] user: drh branch: threads, size: 39023)
2014-04-11
23:14
[d29c8048] part of check-in [0b702759] Add the new interfaces to rtree, though they do not yet work. Add the "show_speedtest1_rtree.tcl" script for showing the test data used for the R-Tree tests of speedtest1. Change speedtest1 to generate better R-Tree test data. (check-in: [0b702759] user: drh branch: rtree-enhancements, size: 44682)
17:41
[01747360] part of check-in [9d485c42] Add the --verify option to speedtest1. Add verification test cases to the "rtree" testset and a case that uses a custom geometry callback. (check-in: [9d485c42] user: drh branch: rtree-enhancements, size: 44581)
16:14
[3e06b48e] part of check-in [20a73ec0] Update comments in the R-Tree module in preparation for some big changes. Add an "rtree" performance test to speedtest1. (check-in: [20a73ec0] user: drh branch: rtree-enhancements, size: 41612)
2014-03-25
20:28
[90446861] part of check-in [7922809e] Adjust the repeat counts on several tests in speedtest1 so that the relative time spent on the test is roughly the same regardless of --size. (check-in: [7922809e] user: drh branch: trunk, size: 38625)
17:45
[2bec9392] part of check-in [9ab7ffd5] Add another performance test case to speedtest1. This case is another ORDER BY test but this time without LIMIT. (check-in: [9ab7ffd5] user: drh branch: trunk, size: 38643)
14:54
[bbf90952] part of check-in [58812264] Add an ORDER BY test case to speedtest1.c (check-in: [58812264] user: drh branch: trunk, size: 38089)
2014-02-09
23:59
[1603da7b] part of check-in [53299575] Add a compound-query test to the speedtest1 test program. (check-in: [53299575] user: drh branch: trunk, size: 37535)
00:52
[8b3b85c8] part of check-in [56febbeb] Add the Mandelbrot Set testcase to the "cte" testset of speedtest1. (check-in: [56febbeb] user: drh branch: trunk, size: 37051)
00:18
[ba90413e] part of check-in [4677ef2f] Add a new "testset" to the speedtest1 program: The sudoku solver. (check-in: [4677ef2f] user: drh branch: trunk, size: 36050)
2013-12-21
17:14
[7130d2cb] part of check-in [2d2b3c49] Fix speedtest1.c so that in --explain mode it only outputs non-explain text for DDL statements. (check-in: [2d2b3c49] user: drh branch: trunk, size: 32783)
15:46
[0fb5502e] part of check-in [96397263] Fix the ".echo on" dot-command of the shell so that it echos comments in addition to SQL statements and dot-commands. Add the --explain option to speedtest1 so that the output can be piped into the command-line shell to show nicely-formated VDBE code for the entire test. (check-in: [96397263] user: drh branch: trunk, size: 32730)
00:04
[60d9ebc6] part of check-in [69a17336] Add a case to speedtest1.c that demonstrates the need to factor OP_Column operators out of inner loops. (check-in: [69a17336] user: drh branch: trunk, size: 32105)
2013-12-18
16:27
[47788d55] part of check-in [97fdfc6b] Remove an unnecessary column-cache flush. Add another test case to the speedtest1.c program to accentuate the benefit of not flushing the cache at that point. (check-in: [97fdfc6b] user: drh branch: column-cache-debug, size: 31546)
2013-12-09
12:24
[bb3a4cc6] part of check-in [fbfc075a] Fix an incorrect test number in the output of the speedtest1.c program. No changes to the test algorithms. (check-in: [fbfc075a] user: drh branch: trunk, size: 31240)
2013-12-02
21:25
[4f1e34b6] part of check-in [bc8eacc7] Another #if SQLITE_VERSION_NUMBER macro in speedtest1.c for compatibility with older versions of SQLite. (check-in: [bc8eacc7] user: drh branch: trunk, size: 31240)
01:24
[ae9d739b] part of check-in [4b20cf42] Still more #if SQLITE_VERSION_NUMBER macros in test/speedtest1.c to enable compilation against older versions of SQLite. (check-in: [4b20cf42] user: drh branch: trunk, size: 31199)
2013-12-01
18:10
[aa1ff125] part of check-in [a9e1627a] Add some #if SQLITE_VERSION_NUMBER macros to test/speedtest1.c in order to make it compatible with older versions of SQLite so that it can be used for historical speed comparisons. (check-in: [a9e1627a] user: drh branch: trunk, size: 31112)
2013-11-27
18:00
[184ded13] part of check-in [ae90300e] Fix spelling typo in speedtest1.exe. (check-in: [ae90300e] user: mistachkin branch: trunk, size: 30915)
14:50
[39921e42] part of check-in [c75f561f] Fix some harmless compiler warnings in speedtest1.exe. (check-in: [c75f561f] user: drh branch: trunk, size: 30914)
2013-11-24
01:14
[aa08ae8e] part of check-in [8f3c767a] Add the --scratch parameter to speedtest1. Improved error messages when misconfiguring memory parameters in speedtest1. (check-in: [8f3c767a] user: drh branch: trunk, size: 30908)
2013-11-23
21:29
[3296bda6] part of check-in [6b98f0af] Add newlines at the end of some error messages in speedtest1. (check-in: [6b98f0af] user: drh branch: trunk, size: 32175)
11:45
[34dfd9e8] part of check-in [659f1a98] Report errors from sqlite3_exec() and sqlite3_config() in speedtest1. Fix a bug in the main testing logic that was found by these error reports. (check-in: [659f1a98] user: drh branch: trunk, size: 32169)
04:32
[19ceb72f] part of check-in [dbe85ef6] Fix the order of parameters to SQLITE_CONFIG_PAGECACHE in the speedtest1.exe program. (check-in: [dbe85ef6] user: drh branch: trunk, size: 31654)
04:16
Added: [b84e185c] part of check-in [fb6f0c6d] Add the "speedtest1.exe" test program. (check-in: [fb6f0c6d] user: drh branch: trunk, size: 31654)