database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
13,071 Commits 1,785 Branches 392 Tags
threadtest3
Commit Graph

298 Commits

Author SHA1 Message Date
drh
c6652b1efe Add the SQLITE_SCANSTAT_SELECTID metric. Use it to improve the 
".stmtscan on" output in the shell.

FossilOrigin-Name: 64ad5761a841f71530d41565b9fbe9d19c2d6aff
 2014-11-06 04:42:20 +00:00
drh
518140ed04 Change the SQLITE_SCANSTAT_EST parameter so that it returns a double for 
the estimated number of output rows per loop, rather than a 64-bit integer.
Revise the output format for the ".scanstats on" in the shell to make use
of this new capability.

FossilOrigin-Name: f9684000665ae7ef6f89c3773612b8286b8f545a
 2014-11-06 03:55:10 +00:00
dan
037b5324bd Remove unused variable from struct WhereInfo. Add some explanatory comments to new code. 
FossilOrigin-Name: f5313e0c680d9baebefb1cf50ddadedd4418a334
 2014-11-03 11:25:32 +00:00
dan
43764a8efb Minor performance enhancements to SQLITE_ENABLE_STMT_SCANSTATUS code. 
FossilOrigin-Name: f13d6ba8a72d75838c4aaf85326c1129da027f8b
 2014-11-01 21:00:04 +00:00
dan
6f9702ed4d If SQLITE_ENABLE_STMT_SCANSTATUS is defined, record the number of times each VDBE opcode is executed. Derive the values returned by sqlite3_stmt_scanstatus() from these records on demand. 
FossilOrigin-Name: 9ea37422a8cc2fce51bb10508e5e90f40fd4b511
 2014-11-01 20:38:06 +00:00
dan
04489b6dce Add the experimental sqlite3_stmt_scanstatus() API. 
FossilOrigin-Name: 6a9bab34aeb6a01b612211a28c140de60a3e883c
 2014-10-31 20:11:32 +00:00
dan
c3da667b25 Modify the documentation for sqlite3_changes() to make it more testable. Add tests and minor fixes for the same. 
FossilOrigin-Name: 41cdd0c422d61533a94870cb5ad094682956d472
 2014-10-28 18:24:16 +00:00
drh
facf47a891 Use the padding word in the Mem object as temporary storage for 
serial_type value in OP_Record, and thus avoid a redundant computation of
the serial_type for each column.

FossilOrigin-Name: 4b3b65ee5ea61e9b9671ca027940bf02689cb890
 2014-10-13 20:12:47 +00:00
drh
c22284f4b3 Reduce the CPU load imposed by sqlit3VdbeCursorMoveto() by factoring out 
some of its functions and by avoiding unnecessary calls.

FossilOrigin-Name: c2799aece17d347c64217a0e407bb10e50c184a3
 2014-10-13 16:02:20 +00:00
drh
b53a5a9e50 Remove the VdbeCursor.lastRowid cache of the current rowid, since maintaining 
the correct cache value uses more CPU cycles than just recomputing the rowid
on the occasions when it is actually needed.  Replace it with the
VdbeCursor.aOffset field which used to be computed from VdbeCursor.aType
when needed. Saves 100 bytes of code space and runs 0.2% faster.

FossilOrigin-Name: 91384a7d727ef0f285cd430e829ba9f3852db50e
 2014-10-12 22:37:22 +00:00
drh
4fa4a54f7e Remove the SQLITE_ENABLE_TREE_EXPLAIN compile-time option. Add alternative 
debugging display routines: sqlite3TreeViewExpr(), sqlite3TreeViewExprList(),
and sqlite3TreeViewSelect().

FossilOrigin-Name: 4ff51325d6b41d0c59e303b573700ec80c51d216
 2014-09-30 12:33:33 +00:00
drh
a15cc47f81 Simplifications to the SQL function and aggregate calling procedures. 
FossilOrigin-Name: 3467049a1705b49905ea88a5c6becb6fe318f2fa
 2014-09-25 13:17:30 +00:00
drh
322f2852f2 Add the sqlite3VdbeMemClearAndResize() interface to be used in place of 
sqlite3VdbeMemGrow().

FossilOrigin-Name: 5b9b8987797abf7c68d2c3154f6657be9b8b1c8f
 2014-09-19 00:43:39 +00:00
drh
17bcb10299 Add the Mem.szMalloc element to the Mem object and use it to keep track of 
the size of the Mem.zMalloc allocation.

FossilOrigin-Name: 9c09ac353df6041808cace41880f4729ee73f5e1
 2014-09-18 21:25:33 +00:00
mistachkin
26c79a060b Correct typos in comments. No changes to code. 
FossilOrigin-Name: 55879932116d373c95a5f32ec44b53a9c3f4db24
 2014-09-18 18:55:47 +00:00
drh
74eaba4de2 Merge the Mem.r value into the MemValue union as Mem.u.r. Hence, a Mem can 
now store an integer or a real but not both at the same time.  Strings are
still stored in a separate element Mem.z, for now.

FossilOrigin-Name: 4c8c89d7e62aecfe2eb735f7bb114aed6b452847
 2014-09-18 17:52:15 +00:00
drh
d3b74200a8 In the Mem object, stop requiring that Mem.xDel be NULL when the MEM_Dyn 
bit is clear.  Also reduce the amount of initialization of Mem objects.
All for a small size reduction and performance increase.

FossilOrigin-Name: fdddb477c89dabb9f7bf2d5ccb32534868df3a03
 2014-09-17 16:41:15 +00:00
drh
0725cabe3a Improved interface to the Mem object handling. Small size reduction and 
performance increase.

FossilOrigin-Name: 4e437844322cc20eef92928b53fa6b37eded586e
 2014-09-17 14:52:46 +00:00
drh
897a2d50f2 Remove an unused parameter from sqlite3VdbeIdxRowid(). This is cosmetic 
only as the C-compiler optimizers were already omitting this parameter on
amalgamation builds.

FossilOrigin-Name: a10a6bba4963761b490b7243b388dcc920c4cfed
 2014-09-16 14:55:08 +00:00
drh
035e563bf6 Reorder the elements of the Mem object for a small size reduction and 
performance improvement.

FossilOrigin-Name: 0be3019ed794c10de67dfd645ceea7d45815bc4b
 2014-09-16 14:16:31 +00:00
peter.d.reid
60ec914c74 Fix typos in comments. No code changes. 
FossilOrigin-Name: e62aab5e9290503869e1f4d5e0fefd2b4dee0a69
 2014-09-06 16:39:46 +00:00
drh
503ae86508 Merge recent performance enhancements from trunk onto the threads branch. 
FossilOrigin-Name: 35c44a3c73e2e8b14ff194c41986f4bdb9dfe737
 2014-08-29 14:40:07 +00:00
drh
9bd038f12e In the sqlite3_context object, keep a pointer to the result value rather 
than storing the result value in the sqlite3_context object and using
memcpy() to move the value back into its register
after the function returns.  This runs faster and saves over 500 bytes
of code space.

FossilOrigin-Name: 6c1ee3e388eb110de815270467b1e50592c0ba6c
 2014-08-27 14:14:06 +00:00
drh
6c4ec84256 Merge the CAST operator enhancements from trunk. 
FossilOrigin-Name: 6c8f86e4e08d5d57e21496277613e0f9dcc06514
 2014-08-25 22:43:17 +00:00
drh
4169e430a2 Allow CAST expressions and unary "+" operators to be used in the DEFAULT 
argument of an ALTER TABLE ADD COLUMN and to be understand on the RHS of
range constraints interpreted by STAT3/4.  This involves a rewrite of the
implementation of the CAST operator.

FossilOrigin-Name: 91d8a8d0b792ea5c4fe68fd9caaf3345eddea486
 2014-08-25 20:11:52 +00:00
drh
4d015c6902 Merge the recent performance enhancements implemented on trunk into the 
threads branch.

FossilOrigin-Name: dfdc900f5d1a31ee5c5f35a630c4a8253e69093b
 2014-08-25 13:27:02 +00:00
drh
12b7c7d8c3 Change the name of the VdbeMemRelease() macro to VdbeMemReleaseExtern() to 
more accurately reflect what it does.  Performance enhancement to the
sqlite3VdbeMemRelease() function.

FossilOrigin-Name: 3ca5846da7da5e08192a4c96288197be3b7ab6f7
 2014-08-25 11:20:27 +00:00
drh
bd9507c8da Performance optimization in the applyAffinity() logic inside the VDBE. 
FossilOrigin-Name: 25f2246be404f38b4f8dd70397cd1454d46358c4
 2014-08-23 17:21:37 +00:00
drh
966d9f267f Merge recent trunk changes into the threads branch. 
FossilOrigin-Name: 163c247bd8280ab14fe577329c631c8bd884707f
 2014-07-28 15:01:37 +00:00
drh
8af3f772c1 Add constraints (enforced only when SQLITE_DEBUG is enabled) on the use of 
OP_Next and OP_Prev.

FossilOrigin-Name: 2230c74f1efa591770176c9b40e920724a3c39e1
 2014-07-25 18:01:06 +00:00
drh
2bd2c29a95 Merge all recent trunk changes into the threads branch. 
FossilOrigin-Name: 770685892c8f09b9cddb2fbb2877cfb291e19425
 2014-07-24 16:54:28 +00:00
drh
3526319b48 Add the OP_ReopenIdx opcode that works like OP_OpenRead except that it becomes 
a no-op if the cursor is already open on the same index.  Update the
OR-optimization logic to make use of OP_ReopenIdx in order to avoid
unnecessary cursor open requests sent to the B-Tree layer.

FossilOrigin-Name: 77f412caf0192d3e7fecb377d6d72123d8b64424
 2014-07-22 20:02:19 +00:00
drh
6614181610 Merge the latest trunk changes into the threads branch. 
FossilOrigin-Name: ae23a65eb1547fbe8b86ab71477071990a22d31d
 2014-06-30 20:25:03 +00:00
drh
3eddb23e31 Change the VDBE to export the sqlite3MemCompare() routine and thus free 
where.c from the dependency on vdbeInt.h.

FossilOrigin-Name: d186d1ac3c47f0d814636c4b8386a6065a294750
 2014-06-28 14:28:06 +00:00
drh
958d261bb8 Fix harmless compiler warnings. 
FossilOrigin-Name: f8f72ecb9052a4cace1db75879fb8b5131ea4f50
 2014-04-18 13:40:07 +00:00
dan
fad9f9a8a6 When sorting data for a CREATE INDEX statement in single-threaded mode, assume that keys are delivered to the sorter in primary key order. Also fix various comments that had fallen out of date. 
FossilOrigin-Name: 821d1ac4504243fa13b9e3c0d56361ad9fb80d78
 2014-04-01 18:41:51 +00:00
drh
a1f7c0a21c Enhance the sqlite3VdbeRecordCompare() routines so that if they encounter 
database corruption, they will set the UnpackedRecord.isCorrupt field and
return 0.  The sqlite3BtreeMovetoUnpacked() routine detects this and returns
SQLITE_CORRUPT, causing the corruption to be reported back to the top-level.

FossilOrigin-Name: 7fa85eaaaf6d211378620d728a759fdfe30a15b0
 2014-03-28 03:12:48 +00:00
drh
65ea12cb4a Make it possible for block-sort to use the OP_SorterOpen sorter in addition 
to a generic OP_OpenEphemeral.

FossilOrigin-Name: 7ce2daafd39a117041bfdd0a7132e2764fe7a74b
 2014-03-19 17:41:36 +00:00
drh
079a307259 First attempt at getting block-sort to work. This is an incremental check-in. 
There are many problems still to be worked out.

FossilOrigin-Name: 59742dd4c5259883850044d0938248b009ebd045
 2014-03-19 14:10:55 +00:00
mistachkin
afc14f72ef Experimental simplification of memory flags/type handling. 
FossilOrigin-Name: bac2820e13a79d91d0f8938c643134a9d6900327
 2014-03-05 01:29:18 +00:00
drh
295aedf097 Fix compiler warnings. 
FossilOrigin-Name: ba8993727e5752cbc92c7d78437e9e0510c899f7
 2014-03-03 18:25:24 +00:00
drh
c91b2fd310 Change the MEM_Dyn flag so that it means that Mem.xDel exists and must be 
used to free the string or blob.  Add tighter invariant checks on Mem.

FossilOrigin-Name: 44e1c33767cae3bf2cbd2238831fe67197009b43
 2014-03-01 18:13:23 +00:00
drh
75fd054201 Factor the Mem invariant checker into a separate procedure (rather than a 
macro) so that it can be more easily extended.

FossilOrigin-Name: 354699d50e7d251504a7b3d6fbec9e5bcf99557f
 2014-03-01 16:24:44 +00:00
drh
defbd9dade Add extra assert() statements trying to catch a Mem object in an inconsistent 
state.

FossilOrigin-Name: 4aeb3ae435c78070232fef21a147fde4e1c5cd31
 2014-03-01 14:45:18 +00:00
drh
1b27b8c0a0 Faster and smaller implementation of sqlite3_value_type(). 
FossilOrigin-Name: 5708bc24b8cab623b833121183042b43e5a7021b
 2014-02-10 03:21:57 +00:00
drh
5f61229504 Do away with the "multi-register pseudo-table" abstration. Instead, just 
use an OP_SCopy to load results directory from the result registers of
the co-routine.

FossilOrigin-Name: 1e64dd782a126f48d78c43a664844a41d0e6334e
 2014-02-08 23:20:32 +00:00
drh
ed71a839fd Change the OP_InitCoroutine instruction to jump over the co-routine 
implementation.

FossilOrigin-Name: a522f364a6b8ca6f69c353b30609a2166f6e94cf
 2014-02-07 19:18:10 +00:00
drh
a5750cfe01 Add the OP_Undef and OP_IsUndef opcodes. With these, use the first register 
in the result register range as the flag to indicate EOF on an INSERT from
a SELECT, rather than allocating a separate boolean register for that task.

FossilOrigin-Name: 6fb7448550f28a3c93053e125faeaf11de1011d0
 2014-02-07 13:20:31 +00:00
drh
73d5b8f550 Move elements of the Vdbe object that are only used during statement 
preparation out into the Parse object.

FossilOrigin-Name: c289a253c0c053ac8fc344efe138262c327d8096
 2013-12-23 19:09:07 +00:00
drh
9ac7962ace Show changes to the column cache when PRAGMA vdbe_addoptrace=ON is set. 
FossilOrigin-Name: 4c6a659c432e4f7c0285f58675a67f967b07bb0d
 2013-12-18 15:11:47 +00:00