database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-26 21:59:27 +03:00
Code Activity
17,644 Commits 1,786 Branches 392 Tags
or-optimization
Commit Graph

12287 Commits

Author SHA1 Message Date
dan
e7eeeb99f7 Fix building with SQLITE_OMIT_FOREIGN_KEY defined. 
FossilOrigin-Name: e93d2c49a44af994ff10cc9cc7eafacd5a4f73ab
 2017-01-30 11:38:19 +00:00
drh
d26cc54183 In the amalgamation, allocate the parser engine object from stack rather than 
from heap, for improved performance.  This only happens in the amalgamation,
since otherwise the sqlite3RunParser() routine does not know the object size.

FossilOrigin-Name: 4fe879d4b5da6ae0688a7a99004683a234966597
 2017-01-28 20:46:37 +00:00
mistachkin
51b15c3871 Fix a couple comment typos. No changes to code. 
FossilOrigin-Name: 2a2e7d86b275c970726f642a37a098950a3b906e
 2017-01-28 19:53:51 +00:00
dan
f64ece143c Avoid redundant table b-tree cursor seeks in UPDATE statements that use the 
two-pass strategy.

FossilOrigin-Name: dc555b1039c6930f6d15355c698ff917a85e8056
 2017-01-28 19:45:34 +00:00
drh
6034d47618 Updates to the sqlite3_blob documentation. No changes to code. 
FossilOrigin-Name: 426b440a5745f9c431c6a3d9ba542af61a6a83fb
 2017-01-28 15:26:14 +00:00
dan
2d2e4f3895 Fix a typo in the docs for sqlite3_update_hook(). 
FossilOrigin-Name: 7c029655cc3369a1e46741fdd3701d36d420b28b
 2017-01-28 06:50:15 +00:00
dan
50133dea28 Fix a problem causing the pre-update hook to be invoked by DROP TABLE 
statements.

FossilOrigin-Name: fbb6bf1b69cfd581b4ffd778c344e3fbd9c9406f
 2017-01-27 17:02:26 +00:00
drh
7aee83b935 In the command-line shell, enhance the ".mode" command so that it restores the 
default column and row separators for modes "line", "list", "column", and
"tcl".

FossilOrigin-Name: 58f02e6eae8fc9e2577fe435b0282fb46af3960d
 2017-01-27 01:52:42 +00:00
drh
6ee610bfc0 Another micro-optimization in accessPayload(). Slightly smaller and faster. 
FossilOrigin-Name: c012619b65d70b4ef6cf33532ef57d7f8ba42d74
 2017-01-27 01:25:00 +00:00
drh
cdf360a0d5 Performance optimization in accessPayload(). 
FossilOrigin-Name: ebb1fd98d4e448aa6d8f1e5be7ddc5bedb3db95b
 2017-01-27 01:13:49 +00:00
drh
42e28f12a3 Simplify the accessPayload() routine so that it always populates the overflow 
page cache.  In the one case where populating the page cache can lead to 
problems, simply invalidate the cache as soon as accessPayload() returns.  
This simplification reduces code size and helps accessPayload() to run a 
little faster.  This backs out the eOp==2 mode of accessPayload() added by 
check-in [da59198505].

FossilOrigin-Name: 68e7a8c6765649195ef1ad9407d87d44a307b462
 2017-01-27 00:31:59 +00:00
drh
945b094632 Remove an unreachable branch in the error handling logic for 
sqlite3BtreePayloadChecked().

FossilOrigin-Name: 293bf3ed7e40745349c83b202b27ed1b48517e1a
 2017-01-26 21:30:00 +00:00
drh
b7dab70a92 Improvement to the OP_Permutation opcode to prevent it from using CPU cycles 
for initialization in prepared statements that do not use that opcode.

FossilOrigin-Name: b4a98f65564a0d9fba2fef95ebd00a39b3e1e572
 2017-01-26 18:00:00 +00:00
drh
fae58d51ce Remove the obsolete lastRowid cache from the sqlite3VdbeExec() for a size 
reduction and performance improvement.

FossilOrigin-Name: b4803184652e5f4f823c1521412bc480baeb3dbf
 2017-01-26 17:26:44 +00:00
drh
d08406477a Performance optimization in sqlite3VdbeCloseStatement(). 
FossilOrigin-Name: 1e96e5ec1ee617cb5b5cbdc5a2ee79c8cc35821d
 2017-01-26 17:11:18 +00:00
drh
83ec2761fa Performance optimization to sqlite3_blob_read(). 
FossilOrigin-Name: 7459f4b7ed4007d9ec44c3bf0fcba04f5f8540a9
 2017-01-26 16:54:47 +00:00
drh
8bb9fd3b45 Minor simplification and performance optimization for Direct Overflow Read. 
FossilOrigin-Name: 3e96d6efa867b765c8acf1454014b1e71b2e4f21
 2017-01-26 16:27:32 +00:00
drh
d930b5cb06 Make SQLITE_DIRECT_OVERFLOW_READ work for in WAL mode as long as the page 
being read is not in the the -wal file.

FossilOrigin-Name: 9879be1899adf5634f551a2077b15ccb1133e4e3
 2017-01-26 02:26:02 +00:00
drh
d447dced96 Trim NULL values off the end of records when the SQLITE_ENABLE_TRIM_NULLS 
compile-time option is used.  Increase the size of the P5 operand to 16 bits.
Fix a problem with short records in the sessions extension.

FossilOrigin-Name: 4801bd59a01dcc11a3eb9e776e7599b36f162d2a
 2017-01-25 20:55:11 +00:00
dan
7271d7a19c Fix another pre-update hook issue, this time in sqlite3preupdate_old(). 
FossilOrigin-Name: c7651d21bfdfd9b8cf04b26e0264bc58c03d247f
 2017-01-25 18:53:27 +00:00
dan
2a86c1962c Fix a problem with the pre-update hook on this branch. 
FossilOrigin-Name: 6fc4fbfa29cfa795edf32e4a1f2d0eceb3007f68
 2017-01-25 17:44:13 +00:00
drh
585ce1923c Experimental enhancement to automatically trim NULL values from the end of 
records, for a reduced disk footprint.  This change also involves increasing
the P5 operand from 8 to 16 bits.

FossilOrigin-Name: 118ded403b95050b74ae2b03919c43d614094a32
 2017-01-25 14:58:27 +00:00
drh
210b0d0eb3 Ensure that sqlite3_blob_reopen() correctly handles short rows. 
Proposed fix for ticket [e6e962d6b0f06f46e].  Further testing needed.

FossilOrigin-Name: 57d8dad35c2a9ab635e954dce7f3986ae1ca8ed2
 2017-01-25 04:41:34 +00:00
drh
6aabff38e9 Optimization: Try to avoid unnecessary btree searching when repositioning 
a cursor to the next row.

FossilOrigin-Name: ee793d30c1dc1f78f49e6230d17750eceedbd8ed
 2017-01-23 16:56:18 +00:00
dan
65c4c0b02d Add the missing SQLITE_API symbol to test_delete.c (it is not added 
automatically as this file is not part of the amalgamation).

FossilOrigin-Name: 7a4f512ddf9e7e718389c80930d6268ab598459c
 2017-01-23 15:58:09 +00:00
drh
38305ab55f Fix an uninitialized variable in the command-line shell. 
FossilOrigin-Name: 06b8001ade62bc59e6ae20f761167a81d85a4272
 2017-01-22 16:34:35 +00:00
mistachkin
35f30d3398 Fixes to documentation comments in the public header file. 
FossilOrigin-Name: 772dcb08f400f20d4dbfb74df39de78da24ee5fd
 2017-01-22 02:04:05 +00:00
drh
7f11afaba1 A better implementation of the moveto-neighbor optimization that checks for 
nearby rows on adjacent pages.

FossilOrigin-Name: 2c4ecb85a475b9063aa8a3bb517ac181a7ded649
 2017-01-21 21:47:54 +00:00
drh
451e76d5b5 B-tree optimization: When seeking on a rowid table that has already been 
positioned, check to see if the new row happens to be the next row on the
same leaf page.  That is a reasonably common case, and if it is true it
avoids a full binary search.

FossilOrigin-Name: 8e5cfb2039126da7689c4b1c88760f10e1234eaf
 2017-01-21 16:54:19 +00:00
drh
3b2936fada Change sqlite3_blob_reopen() to call sqlite3VdbeExec() directly rather than 
going through sqlite3_step().  Performance enhancement.

FossilOrigin-Name: 347df3c1fd7322e7aacaf1e9f8be81830947c482
 2017-01-21 16:27:56 +00:00
drh
36cae856ee Remove an unnecessary sqlite3_bind_int64() call from sqlite3_blob_open(). 
Also other minor refactoring of the sqlite3_blob implementation.

FossilOrigin-Name: 9d197a532349f4b1caf66bbed70ca46df86cb86f
 2017-01-21 14:11:28 +00:00
drh
cd64553015 Minor performance optimization and size reduction to the accessPayload() 
routine in btree.c.

FossilOrigin-Name: 264e5c10d7144910b3223b64546567fa20e4bc65
 2017-01-20 20:43:14 +00:00
drh
4df65fc20f Minor performance optimizations to sqlite3_blob_open() and 
sqlite3_blob_reopen().

FossilOrigin-Name: 52a61967d920047ea0b4409b79793e05c0128964
 2017-01-20 00:40:26 +00:00
drh
8674e49214 If compiled with SQLITE_INLINE_MEMCPY, all memcpy() calls are replaced with 
in-line code.  With that change, cachegrind shows which memcpy() calls
are taking the most time.  This is a performance-measurement hack only and
is not for production use.

FossilOrigin-Name: 9ed38521617136223a667988aed40e25797faf84
 2017-01-19 21:20:11 +00:00
mistachkin
aac853bae8 In the 'windirent' test module, use a macro for the hidden/system attribute checking. 
FossilOrigin-Name: a84a08d0716656dc0b26eafb1841c48d83c67ef2
 2017-01-18 22:47:42 +00:00
mistachkin
8a9e83583b Fix handling of initial hidden and/or system files in the opendir() implementation for Windows. No changes to non-test code. 
FossilOrigin-Name: 26dd42b462dc621b8b0a2295fc91d3e61ac732b6
 2017-01-18 22:16:20 +00:00
drh
c711f53f30 Disable intrinsic functions for Windows using Clang, due to reports of 
linkage errors.  This causes a 0.6% performance reduction.  We will want to
revisit this change in the future.

FossilOrigin-Name: 7fd560c6d2ff470b755ad118287a0a8825b3009e
 2017-01-17 00:10:58 +00:00
drh
da060052e3 Back out check-in [0b3174e0b1364c] and replace it with a better fix 
for ticket [91e2e8ba6ff2e2] - a fix that does not cause the problem
identified by ticket [7ffd1ca1d2ad4ec].

FossilOrigin-Name: 0613665274346917f5482f9210bf0c60a0fed7d9
 2017-01-16 16:43:02 +00:00
drh
be7a0cee4e Fix the build for SQLITE_ENABLE_MEMORY_MANAGEMENT. 
FossilOrigin-Name: 8c85b8fdd7f0ba65fba83361d361a567b797a184
 2017-01-13 12:53:35 +00:00
drh
7b20a15d13 Remove a branch that is probably unreachable, and which adds no value. 
FossilOrigin-Name: 9acc72381ccd5e36f3ffdf7e7fbefc5a15701eb4
 2017-01-12 19:10:55 +00:00
drh
ae051a8970 Fix harmless compiler warnings in the UPDATE code generator. 
FossilOrigin-Name: 385db266673abaf7013ffad09b28014c246547ef
 2017-01-12 16:21:54 +00:00
drh
70d90a2c37 Remove an unnecessary corruption test from the btree balancer. If corruption 
is present, it will be found harmlessly by later tests.

FossilOrigin-Name: bddf39562d08e259c43dd59b82afb62fe0eb2eef
 2017-01-12 16:14:33 +00:00
drh
b701c9a6c3 Improved detection of cells that extend into the reserved space at the end 
of the page while adjusting overflow page pointers during autovacuum.

FossilOrigin-Name: 8097712c9c1f4ea16bc5dd462da248ef98896061
 2017-01-12 15:11:03 +00:00
drh
ea8f0a155e Make sure Tcl_AppendResult() always has a NULL-pointer argument at the end. 
FossilOrigin-Name: c07aef6f909fe35de110f0b180dbf5aa4c226af3
 2017-01-12 11:50:08 +00:00
dan
ba47020b63 Changes to allow some multi-row UPDATE statements to avoid the two-pass 
approach.

FossilOrigin-Name: 7ae6104a3e0d1d2cacfe2be732f0220a53908132
 2017-01-11 21:03:53 +00:00
dan
e206ea7f48 Fix a problem causing the pre-update hook to be passed an incorrect rowid 
value in some single-pass multi-row updates.

FossilOrigin-Name: 62257eb53c13d4c7ed128d5d89f6f10d4aff945c
 2017-01-11 20:10:30 +00:00
dan
2c6fec21dc Fix a problem with single-pass multi-row UPDATE statements that invoke REPLACE 
conflict handling.

FossilOrigin-Name: 0a2b8e1b9dc600b5a93622e8eea6218649df5e0f
 2017-01-11 19:03:08 +00:00
dan
372f942f17 Fix a problem preventing UPDATE statements that use a range-scan on the PK 
index of a WITHOUT ROWID table from using a one-pass strategy.

FossilOrigin-Name: cab86c90945126c24c40cf2dedd053a8c46d00d6
 2017-01-11 15:42:14 +00:00
drh
785d8ed0d4 In the STAT4 computations, ensure that the aAvgEq values do not go negative. 
FossilOrigin-Name: f58f75b5a06f88ba97bd1a02bee621c64691c6f8
 2017-01-11 14:15:29 +00:00
dan
f91c1318f4 Changes to allow some multi-row UPDATE statements to avoid the two-pass 
approach.

FossilOrigin-Name: 46db23ccd116ce5b9d949f9293be8a2818411b46
 2017-01-10 20:04:38 +00:00