Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/speedtest1.c
|
2019-05-25
| ||
| 13:14 | Add new cases to speedtest1 for measuring performance of binary to/from decimal conversions of floating point values. file: [f3bfe3c6] check-in: [b84e7057] user: drh branch: trunk, size: 77058 | |
|
2018-05-24
| ||
| 16:18 | Addition cases for rtree preformance testing in speedtest1.c. Add the --nodiff option to the speed-check.sh script. file: [cc7e6b4a] check-in: [95f2d62c] user: drh branch: trunk, size: 76675 | |
|
2018-04-03
| ||
| 20:44 | Fix an error message in speedtest1.c and make the "trigger" testset sensitive to the --size parameter. file: [20cc4028] check-in: [5a6fd9e0] user: drh branch: trunk, size: 75221 | |
| 20:00 | Update speedtest1.c with new testset "trigger" based on the tests in speed4p.test. file: [3f174276] check-in: [7b7fa5fa] user: dan branch: trunk, size: 75176 | |
|
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 | |