database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-05 15:55:57 +03:00
Code Activity
30,215 Commits 1,570 Branches 183 Tags
tcl-init
Commit Graph

1674 Commits

Author SHA1 Message Date
drh
2343c7eb3f This is an experimental patch that ensures that all cursors have their position 
saved prior to starting a ROLLBACK TO.

FossilOrigin-Name: 01d97e5b6502b1811b52a681f445e1aaae6c0ee6
 2017-02-02 00:46:55 +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
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
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
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
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
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
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
drh
9cc5b4eeb5 Remove an incorrect ALWAYS() macro from balance_nonroot(), which could result 
in corrupt databases if it were optimized out.  This ALWAYS was added 
only two weeks ago (check-in [f9f2e23bbd68a]) and has never appeared in an
official release.

FossilOrigin-Name: e447b23cfd7bb31817e42adb3a98868d351c6b8a
 2016-12-26 01:41:33 +00:00
drh
a582b01698 Simplifications to the way UnpackedRecord objects are allocated. Smaller 
and faster code that also fixes a subtle (currently unreachable) bug.

FossilOrigin-Name: f7ab01f254cd9d7006b8dec29adb234a671b8e6f
 2016-12-21 19:45:54 +00:00
drh
380c08eaad Fix harmless compiler warnings. 
FossilOrigin-Name: ed2c9f3738c96d8e3dbece7ccb721cb1a8ae8fac
 2016-12-13 20:30:29 +00:00
drh
2a70254f74 Remove unnecessary MemPage initialization resets in the autovacuum ptrmap 
processing.

FossilOrigin-Name: 1b36fbb9f05f3a5844e198b489bff36ef6cd908c
 2016-12-12 18:12:03 +00:00
drh
77dc0ed621 Size and performance optimization in btreeInitPage() in the freeblock 
validation step.

FossilOrigin-Name: 57deb1b412e0c328528f2b4d697e326bfd028dca
 2016-12-12 01:30:01 +00:00
drh
f0bc50aa3a Change the order of comparison for divider cell overflow in balance non-root 
to avoid a (harmless) reference to an uninitialized variable.

FossilOrigin-Name: f9f2e23bbd68a8994621623446868d666df52eff
 2016-12-12 00:58:40 +00:00
drh
8c730bc5c5 Avoid an unnecessary memset() in the sqlite3BtreeInsert() routine. 
FossilOrigin-Name: 35ecd4ebc55579175f7c934e4eb1edb969008428
 2016-12-10 13:12:55 +00:00
drh
2d08343a91 When doing the sqlite3BtreeInsert() overwrite optimization, make sure the 
memcpy() does not extend off the end of the page.

FossilOrigin-Name: 684ef4582ed19b2af22dda6fc085c70464f92f1b
 2016-12-09 19:42:18 +00:00
drh
f923825424 Additional comments and an assert on the sqlite3BtreeInsert() overwrite 
optimization.

FossilOrigin-Name: c1f0ae9d2981a19875103750379ad26f2575f878
 2016-12-09 18:09:42 +00:00
drh
80159da6c6 In sqlite3BtreeInsert() when replacing a re-existing row, try to overwrite 
the cell directly rather than deallocate and reallocate the cell.

FossilOrigin-Name: 0b86fbca6615ccf1f3a62614db577a8acbec6d9e
 2016-12-09 17:32:51 +00:00
drh
a2ee589c46 Avoid unnecessary zeroing of fields in the MemPage object that are going 
to be reinitialized before use anyhow.  A smaller and faster binary results.

FossilOrigin-Name: 01ada3d1068476f90dcae02cb089001ea4bcc23d
 2016-12-09 16:02:00 +00:00
drh
cb3cabd01b Refactor the sqlite3BtreeKey() and sqlite3BtreeData() internal interfaces 
into sqlite3BtreePayload() and sqlite3BtreePayloadChecked(), respectively.
This is a continuation of the optimization started by check-in
[2d831074cf].  The result is a slightly smaller and faster binary.

FossilOrigin-Name: 49ebc219faea30eaa61def4a3fba2817b9c58a86
 2016-11-25 19:18:28 +00:00
drh
65f38d960d Remove unnecessary OP_Close opcodes for a size reduction and performance 
increase.

FossilOrigin-Name: 32be7aae92ee48bf2cd260ea41e79c2bc62738f9
 2016-11-22 01:26:42 +00:00
drh
d6ef5afe3f Change the OP_Last opcode so that it is a no-op if the cursor is already 
pointing at the end of the b-tree.

FossilOrigin-Name: 663473850c4274270445b3771911fa773a8c405f
 2016-11-15 04:00:24 +00:00
drh
d95ef5cb5a Remove obselete and unused logic in the update code generator. 
Fix the sqlite3BtreeMovetoUnpacked() routine so that it remembers the
rowid of the row that it landed on.

FossilOrigin-Name: 1a587d72f981cb7064cfd8916a52a83ad9ba6074
 2016-11-11 18:19:05 +00:00
drh
7a1c28defe Avoid a few unnecessary calls to sqlite3BtreeMovetoUnpacked(). 
FossilOrigin-Name: eac0e827a61cfec4dd9b6d407ff398e9fda3510b
 2016-11-10 20:42:08 +00:00
drh
eaf6ae2992 Comment changes that attempt to better explain the behavior of the "seekResult" 
field on VdbeCursor objects and the seekResult parameter to
sqlite3BtreeInsert() and the OPFLAG_USESEEKRESULT flag on insert opcodes.
No changes to code.

FossilOrigin-Name: 345b46be75bdf6f9fb7367a6164d89bae11995a6
 2016-11-09 20:14:34 +00:00
drh
9b4eaebc68 Enhance the OP_IdxInsert opcode to optionally accept unpacked key material. 
FossilOrigin-Name: 89d958abbac45f2ca5954080cd9e74ec9a07ebb2
 2016-11-09 00:10:33 +00:00
drh
7ad3eb63cf Performance optimization in moveToRoot(). Avoid repeated validity checking of 
the root page on each call. Once is enough.

FossilOrigin-Name: 98795c2dd9a6d8fa8d49a9f5c36cdf824cae7246
 2016-10-24 01:01:09 +00:00
dan
e24452edef Avoid using the "direct overflow read" optimization to read large blobs if the 
pager layer has a wal file open - even if the database header indicates that
the db is not a wal database.

FossilOrigin-Name: b54c15f11796a75683eec4b502a22ccb87d621c6
 2016-10-21 10:49:39 +00:00
dan
1480095ff5 Changes to support interrupting a checkpoint using sqlite3_interrupt(). 
FossilOrigin-Name: c88d36e251abec24aa7e37cf550e148904b9fd2d
 2016-10-17 15:28:39 +00:00
drh
44728d7e01 Do not bother to initialize unused fields in the BtreePayload object. 
FossilOrigin-Name: b10d0f939c82c4de3faa90b86de9ec4a89992856
 2016-10-04 00:47:26 +00:00
drh
cb43a937e5 Allocate Parse objects off of the stack where appropriate for a substantial 
performance increase and a size reduction.

FossilOrigin-Name: ea8affa9e453b201b479162f621b591e7a65a489
 2016-10-03 01:21:51 +00:00
drh
85f071b850 Small performance optimization in the freeSpace() routine of btree.c. 
FossilOrigin-Name: 63962e2a927963575be74c3ce11f39f722c07c72
 2016-09-17 19:34:32 +00:00
dan
0f5a186c4c Questionable changes to support interruptible checkpoint in ZipVFS. 
FossilOrigin-Name: c7a9f26d118c7a453d45fa73efa4d1ab79301659
 2016-08-13 14:30:23 +00:00
dan
7fb8990688 Have wal file checkpoints exit early if the sqlite3_interrupt() API function is called. 
FossilOrigin-Name: 8a5f41c7b1718507524adef1a2730e99cf53270a
 2016-08-12 16:21:15 +00:00
drh
c0d269e96c Fix a typo in a comment in btree.c. No changes to code. 
FossilOrigin-Name: 722c12816347ee9fce7a090cfebef2c5841e7445
 2016-08-03 14:51:16 +00:00
drh
0b4c042b86 Minor tweak the the b-tree balancer. 
FossilOrigin-Name: d2a0af7a37e390439c3001fedb5834f47fb24a1f
 2016-07-14 19:48:08 +00:00
dan
272989b44d Add the SQLITE_DBSTATUS_PROPORTIONAL_CACHE_USED sqlite3_db_status() parameter. 
FossilOrigin-Name: 118321c8b9d88b8f439c952436f42838c3fc80cb
 2016-07-06 10:12:02 +00:00
drh
debaa86c1c Fix an incorrect assert() in the btree logic. 
FossilOrigin-Name: fcf6114be94b260641e7c78a58db16a31ac5ab35
 2016-06-13 12:51:20 +00:00
drh
05a360913d Small performance boost and size decrease in sqlite3BtreeMovetoUnpacked(). 
FossilOrigin-Name: e106a77d85c20ae23ebe49a5acceeaffecb40fc2
 2016-06-06 01:54:20 +00:00
drh
5e08d0fcb6 Improved comment on cursorOwnsBtShared(). No changes to code. 
FossilOrigin-Name: 5e269c2d2667df65592a32d6bc2fa388fd7eb181
 2016-06-04 21:05:54 +00:00
drh
d66c4f809d Fix a C99-ism and a compiler warning for MSVC. 
FossilOrigin-Name: aa53a36ea2eb90cc4939e37e6ad320b4211692fd
 2016-06-04 20:58:35 +00:00
drh
a7c90c42ea Change the sqlite3BtreeKeySize() interface into sqlite3BtreeIntegerKey() and 
make it only work for table btrees.  Change sqlite3BtreeDataSize() into
sqlite3BtreePayloadSize() and make it work for all btrees.  Combine
sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() into a single
sqlite3BtreePayloadFetch() routine.  These changes seem to make the
b-tree interface more rational and they reduce both binary size and
CPU usage.

FossilOrigin-Name: bef35e18dd19732f7859287b097feeb593e5900f
 2016-06-04 20:37:10 +00:00
drh
dfc2daa7c3 More tweaks to improve the performance of the insert logic, slightly. 
FossilOrigin-Name: dec1307581216e01ad508ffe4455b957e3356654
 2016-05-21 23:25:29 +00:00