SQLite

Check-in [b1c0f0bc1b]
Login

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

Overview
Comment:Add support for using separate worker threads to speed large sorts. The SQLITE_MAX_WORKER_THREADS and SQLITE_DEFAULT_WORKER_THREADS compile-time options and the SQLITE_LIMIT_WORKER_THREADS argument to sqlite3_limit() and the "PRAGMA threads=N" pragma are added.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b1c0f0bc1bd8a3477cd7a7ab510f0442ac88b517
User & Date: drh 2014-09-01 17:36:46.754
References
2015-01-20
18:11 Fixed ticket [f97c463710]: Incorrect ordering with ORDER BY and LIMIT plus 4 other changes (artifact: ac59934aff user: drh)
2015-01-19
15:31 New ticket [f97c463710]. (artifact: fc35a8b205 user: drh)
Context
2014-09-01
18:21
Tweak the documentation for SQLITE_LIMIT_WORKER_THREADS. No changes to executable code. (check-in: 672e7387b1 user: drh tags: trunk)
17:36
Add support for using separate worker threads to speed large sorts. The SQLITE_MAX_WORKER_THREADS and SQLITE_DEFAULT_WORKER_THREADS compile-time options and the SQLITE_LIMIT_WORKER_THREADS argument to sqlite3_limit() and the "PRAGMA threads=N" pragma are added. (check-in: b1c0f0bc1b user: drh tags: trunk)
13:37
Attempt to make the xDelete method of the unix VFS more robust on VxWorks. (check-in: b0f6b91f36 user: drh tags: trunk)
2014-08-29
19:06
Disable worker threads when SQLITE_THREADSAFE=0. Set the default compile-time maximum number of worker threads to 8 and honor the SQLITE_DEFAULT_WORKER_THREADS compile-time constant (which defaults to 0). (Closed-Leaf check-in: 33fa041049 user: drh tags: threads)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to Makefile.in.
Changes to Makefile.msc.
Changes to main.mk.
Changes to src/btree.c.
Changes to src/build.c.
Changes to src/main.c.
Changes to src/os_win.c.
Changes to src/pragma.c.
Changes to src/select.c.
Changes to src/sqlite.h.in.
Changes to src/sqliteInt.h.
Changes to src/test1.c.
Changes to src/test_config.c.
Changes to src/test_malloc.c.
Added src/threads.c.
Changes to src/vdbe.c.
Changes to src/vdbeInt.h.
Changes to src/vdbeaux.c.
Changes to src/vdbesort.c.
Changes to test/malloc.test.
Changes to test/mallocA.test.
Changes to test/permutations.test.
Changes to test/sort.test.
Added test/sort2.test.
Added test/sort3.test.
Added test/sort4.test.
Added test/sortfault.test.
Changes to test/speedtest1.c.
Changes to test/tester.tcl.
Changes to tool/mkpragmatab.tcl.
Changes to tool/mksqlite3c-noext.tcl.
Changes to tool/mksqlite3c.tcl.