/ File History
Login

History of test/speedtest1.c

2017-12-26
14:12
Add options to speedtest1.c and speed-check.sh for testing performance of floating-point computatations. file: [a5faf4cb] check-in: [b3c61051] user: drh branch: mistake, size: 68673
2017-10-04
17:05
Update the speedtest1 program so that it prints the output of "PRAGMA compile_options" if the -stats option is specified. file: [e44c5fcc] check-in: [7c69f8f1] user: dan branch: trunk, size: 66476
2017-08-28
15:51
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. file: [7a6ec22e] check-in: [54b00024] user: drh branch: trunk, size: 66231
2017-02-14
16:30
More realistic lengths of string values in speedtest1 with --testset orm. file: [7b1ab42b] check-in: [e4731fd6] user: drh branch: trunk, size: 67339
15:58
Fix a testcase number on the ORM testset of speedtest1. file: [4f7a10a3] check-in: [58b2f911] user: drh branch: trunk, size: 67332
15:57
Add the new "--testset orm" to the speedtest1 utility. file: [89795b8e] check-in: [1836adc1] user: drh branch: trunk, size: 67332
2017-01-20
16:09
Get the "--testset rtree" option working on speedtest1. Add the --rtree, --lookaside, and --clang options to the speed-check.sh script. file: [02fe15bb] check-in: [87b640c8] user: drh branch: trunk, size: 54313
2016-12-31
18:37
In speedtest1.c, make the "--lookaside 0 0" option completely disable lookaside. file: [4e8ea616] check-in: [52b99bcb] user: drh branch: speedtest1, size: 54527
14:33
Minor #include change to speedtest1.c so that it will compile under MSVC. file: [2feca857] check-in: [8c28fde0] user: drh branch: speedtest1, size: 54526
2016-12-12
23:24
Add the --mmap option to the speedtest1 program and to the speed-check.sh script that is frequently used to run speedtest1. file: [0c92fd0d] check-in: [1a636d5e] user: drh branch: trunk, size: 54480
2016-11-21
18:15
Enhance speedtest1.c so that is works on older versions of SQLite, before the introduction of the group_concat() aggregate function. file: [dae4b22c] check-in: [9979ba80] user: drh branch: trunk, size: 54059
2016-11-15
21:17
Add a needed #include to speedtest1.c. file: [2699cdb3] check-in: [77aeb705] user: drh branch: trunk, size: 52283
2016-11-09
01:07
Add a DISTINCT query to speedtest1.c. Also change INSERT OR REPLACE into just REPLACE. file: [48d82e01] check-in: [754ee844] user: drh branch: trunk, size: 52263
2016-11-08
16:27
Fix the speedtest1.c test program so that it gives closing "%" wildcards on LIKE searches. file: [cb433ff7] check-in: [c2f84f63] user: drh branch: trunk, size: 52126
00:30
Tweaks to speedtest1.c to better reflect mobile usage based on findings in the "Pocket Data" paper by Kennedy, Ajay, Challen, and Ziarek. file: [4b2538e9] check-in: [b5733cae] user: drh branch: trunk, size: 52120
2016-10-18
15:29
Fix harmless uninitialized variable warnings in speedtest1.c. file: [ffb96750] check-in: [2aa7a03b] user: drh branch: trunk, size: 50052
14:35
Add the --repeat option to speedtest1.c and speed-check.sh. file: [0258bb62] check-in: [6ca0e06b] user: drh branch: trunk, size: 50037
2016-09-21
23:58
Fix speedtest1.c so that it works with SQLITE_OMIT_DEPRECATED. Add the --lean and --cachesize options to speed-check.sh. file: [43b25ae8] check-in: [7785b3a2] user: drh branch: trunk, size: 49411
2016-06-04
16:33
Fix up speedtest1.c so that it will compile and run on SQLite versions prior to 3.6.18 (circa 2009-09-11). file: [28221f43] check-in: [9583c0fb] user: drh branch: trunk, size: 49306
2016-04-12
17:13
Fix speedtest1 so that it automatically unlinks its test database prior to startup. file: [4476f703] check-in: [b65b69f6] user: drh branch: trunk, size: 49216
16:59
Add the --temp option to the speedtest1.c performance test program. file: [870ea1f3] check-in: [8053a6e2] user: drh branch: trunk, size: 49250
2016-03-30
12:20
Improvements to the performance testing program "speedtest1.c" and the shell script that invokes it. file: [21af8db2] check-in: [e4bee561] user: drh branch: trunk, size: 48619
2016-02-27
19:19
Tighter description of I/O stats in the shell. Show I/O stats on speedtest1.c. file: [1478cb3f] check-in: [f681d800] user: drh branch: trunk, size: 48607
2016-02-19
16:19
Enhance speedtest1 to display the particular version of SQLite under test. file: [947421c3] check-in: [0cb728c1] user: drh branch: trunk, size: 47327
2015-10-29
13:48
Fix uses of ctype functions (ex: isspace()) on signed characters in test programs and in some obscure extensions. No changes to the core. file: [f8bf0421] check-in: [34eb6911] user: drh branch: trunk, size: 47187
2015-07-23
20:44
Change the name of the OTA extension to RBU: Resumable Bulk Update. file: [85743986] check-in: [017c5019] user: drh branch: trunk, size: 47093
2015-07-06
18:54
Enhance separate pcache1 to allocate a block of pages from heap on startup, if possible, for a 5.2% performance improvement. file: [54f21199] check-in: [aa7341c8] user: drh branch: pcache-bulk-local, size: 47093
2015-07-03
14:34
New command-line options for speedtest1: --multithread, --nomemstat, --serialized, and --singlethread file: [2e8f367c] check-in: [2b756722] user: drh branch: trunk, size: 46976
2015-07-02
01:38
Add the --shrink-memory option to the speedtest1 test program. file: [a2834483] check-in: [c9ddbd88] user: drh branch: trunk, size: 46349
2015-06-18
15:26
Further #ifdef changes in speedtest1.c in order to support SQLite back to version 3.3.9 and perhaps even earlier. file: [f42fd04a] check-in: [9246eca5] user: drh branch: trunk, size: 45836
12:37
Add #ifdefs to some features speedtest1.c so that it compiles with older versions of SQLite, going back to version 3.5.1. file: [613e7f60] check-in: [f50dd154] user: drh branch: trunk, size: 45700
2015-03-05
16:21
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. file: [9f1b745c] check-in: [46119e8d] user: dan branch: ota-update, size: 45529
2015-02-03
19:20
Fix a typo in the --help output for speedtest1. Fix a dependency error in the Makefile.in for speedtest1. file: [2b416dca] check-in: [f30a057a] user: drh branch: trunk, size: 45298
2014-10-11
10:52
Require the SQLITE_ENABLE_RTREE compile-time option in speedtest1.c in order to enable the R-Tree tests. file: [e4e2aa37] check-in: [5d29a033] user: drh branch: trunk, size: 45301
2014-08-29
18:06
Fix the speedtest1.c test program to set the worker thread count using the threads pragma. file: [83f6b331] check-in: [2ab4b5ad] user: drh branch: threads, size: 45004
2014-05-02
18:05
Merge orderby-planning with this branch. file: [f452891e] check-in: [d9549de3] user: dan branch: threads, size: 45080
2014-04-18
13:57
Add to speedtest1.c the --threads option for setting the SQLITE_CONFIG_WORKER_THREADS configuration. file: [bd150a4c] check-in: [5fce40c4] user: drh branch: threads, size: 39023
2014-04-11
23:14
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. file: [d29c8048] check-in: [0b702759] user: drh branch: rtree-enhancements, size: 44682
17:41
Add the --verify option to speedtest1. Add verification test cases to the "rtree" testset and a case that uses a custom geometry callback. file: [01747360] check-in: [9d485c42] user: drh branch: rtree-enhancements, size: 44581
16:14
Update comments in the R-Tree module in preparation for some big changes. Add an "rtree" performance test to speedtest1. file: [3e06b48e] check-in: [20a73ec0] user: drh branch: rtree-enhancements, size: 41612
2014-03-25
20:28
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. file: [90446861] check-in: [7922809e] user: drh branch: trunk, size: 38625
17:45
Add another performance test case to speedtest1. This case is another ORDER BY test but this time without LIMIT. file: [2bec9392] check-in: [9ab7ffd5] user: drh branch: trunk, size: 38643
14:54
Add an ORDER BY test case to speedtest1.c file: [bbf90952] check-in: [58812264] user: drh branch: trunk, size: 38089
2014-02-09
23:59
Add a compound-query test to the speedtest1 test program. file: [1603da7b] check-in: [53299575] user: drh branch: trunk, size: 37535
00:52
Add the Mandelbrot Set testcase to the "cte" testset of speedtest1. file: [8b3b85c8] check-in: [56febbeb] user: drh branch: trunk, size: 37051
00:18
Add a new "testset" to the speedtest1 program: The sudoku solver. file: [ba90413e] check-in: [4677ef2f] user: drh branch: trunk, size: 36050
2013-12-21
17:14
Fix speedtest1.c so that in --explain mode it only outputs non-explain text for DDL statements. file: [7130d2cb] check-in: [2d2b3c49] user: drh branch: trunk, size: 32783
15:46
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. file: [0fb5502e] check-in: [96397263] user: drh branch: trunk, size: 32730
00:04
Add a case to speedtest1.c that demonstrates the need to factor OP_Column operators out of inner loops. file: [60d9ebc6] check-in: [69a17336] user: drh branch: trunk, size: 32105
2013-12-18
16:27
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. file: [47788d55] check-in: [97fdfc6b] user: drh branch: column-cache-debug, size: 31546
2013-12-09
12:24
Fix an incorrect test number in the output of the speedtest1.c program. No changes to the test algorithms. file: [bb3a4cc6] check-in: [fbfc075a] user: drh branch: trunk, size: 31240
2013-12-02
21:25
Another #if SQLITE_VERSION_NUMBER macro in speedtest1.c for compatibility with older versions of SQLite. file: [4f1e34b6] check-in: [bc8eacc7] user: drh branch: trunk, size: 31240
01:24
Still more #if SQLITE_VERSION_NUMBER macros in test/speedtest1.c to enable compilation against older versions of SQLite. file: [ae9d739b] check-in: [4b20cf42] user: drh branch: trunk, size: 31199
2013-12-01
18:10
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. file: [aa1ff125] check-in: [a9e1627a] user: drh branch: trunk, size: 31112
2013-11-27
18:00
Fix spelling typo in speedtest1.exe. file: [184ded13] check-in: [ae90300e] user: mistachkin branch: trunk, size: 30915
14:50
Fix some harmless compiler warnings in speedtest1.exe. file: [39921e42] check-in: [c75f561f] user: drh branch: trunk, size: 30914
2013-11-24
01:14
Add the --scratch parameter to speedtest1. Improved error messages when misconfiguring memory parameters in speedtest1. file: [aa08ae8e] check-in: [8f3c767a] user: drh branch: trunk, size: 30908
2013-11-23
21:29
Add newlines at the end of some error messages in speedtest1. file: [3296bda6] check-in: [6b98f0af] user: drh branch: trunk, size: 32175
11:45
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. file: [34dfd9e8] check-in: [659f1a98] user: drh branch: trunk, size: 32169
04:32
Fix the order of parameters to SQLITE_CONFIG_PAGECACHE in the speedtest1.exe program. file: [19ceb72f] check-in: [dbe85ef6] user: drh branch: trunk, size: 31654
04:16
Add the "speedtest1.exe" test program. file: [b84e185c] check-in: [fb6f0c6d] user: drh branch: trunk, size: 31654 Added