paulhorn/sqlite
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
3,805 Commits 1,696 Branches 387 Tags
version-3.3.17
Commit Graph

58 Commits

Author SHA1 Message Date
drh 538f570cd1 Fix multiple performance regressions (ticket #2298 among them) 
and add tests to make sure they do not come back. (CVS 3839)

FossilOrigin-Name: 32bb2d5859906b4fb0f6083eedd7f3a81b9cf5e2
 2007-04-13 02:14:30 +00:00
drh 80e35f4640 Refactoring the btree and pager routines into distinct two-phase commit 
routines.  We've always done a two-phase commit - this change is just
making that more apparent in the code. (CVS 3762)

FossilOrigin-Name: 66b3ad09ea657d25d48cb75ec2671ea2dc1b6005
 2007-03-30 14:06:34 +00:00
danielk1977 979f38e5ee Test handling of IO errors that occur in OsDelete() or OsTruncate() operations. Also use an anonymous file for temporary storage during a VACUUM. (CVS 3729) 
FossilOrigin-Name: b24a6e7b024c8b9a0b6fd15bd8f247e458781ca2
 2007-03-27 16:19:51 +00:00
danielk1977 414834686c Changes for exclusive access mode. There are still some bugs. (CVS 3712) 
FossilOrigin-Name: b6c700370be29db2b974f9abd719c3e56abf8058
 2007-03-24 16:45:04 +00:00
danielk1977 3b8a05f681 Modify the interface to the pager sub-system in preparation for performing IO in blocks based on sector-size, not database page-size. (CVS 3705) 
FossilOrigin-Name: 7dc7658887046f066b564a5994578074a99756ba
 2007-03-19 17:44:26 +00:00
drh 0787db6519 Changes to the btree and pager that reduce the amount of I/O when dealing 
with the freelist.  (1) Avoid journaling pages of a table that is being
deleted.  (2) Do not read the original content of pages being pulled off
of the freelist. (CVS 3671)

FossilOrigin-Name: 2ba5be311945a4c15b6dce7c01efefb513b9a973
 2007-03-04 13:15:27 +00:00
drh 551b77365e Use the difference between the SQLITE_IOERR_SHORT_READ and SQLITE_IOERR_READ 
returns from sqlite3OsRead() to make decisions about what to do with the
error. (CVS 3503)

FossilOrigin-Name: 6324ea811eec1200cee89e6f377368eaf2fcda77
 2006-11-06 21:20:25 +00:00
drh 0f7eb61108 Remove most static and global variables from a pure build. There 
are still a number of static and global variables used for testing. (CVS 3342)

FossilOrigin-Name: 76e4d4187779097954038e444111f837737e789c
 2006-08-08 13:51:43 +00:00
drh c001c58a72 Pager performance enhancements. (CVS 3125) 
FossilOrigin-Name: 9c26570743d878dee963e37728969fb30a2fb436
 2006-03-06 18:23:16 +00:00
drh ac530b1ab4 Add support and documentation for the fullfsync pragma. Also include 
some other unrelated documentation updates. (CVS 3080)

FossilOrigin-Name: f2069d0bf3161591535e68b7389792e9cb7fe043
 2006-02-11 01:25:50 +00:00
danielk1977 0190d1da46 Add some very simple test cases (and resulting bug fixes) for release_memory(). (CVS 2826) 
FossilOrigin-Name: 154282fca54bf03d310d6931660f99805bb5477f
 2005-12-19 14:18:11 +00:00
danielk1977 13f7299bbe Add the (untested) sqlite3_release_memory() function. (CVS 2825) 
FossilOrigin-Name: 345addaa03d3bfa3429a59597fbd3addcff62e30
 2005-12-18 08:51:22 +00:00
drh eb8cbaeb18 Set the default maximum page size to 32768, not 8192. (CVS 2724) 
FossilOrigin-Name: b32e9ec2480f9da2c2ea705ed3c88ca77b77cf2a
 2005-09-19 19:05:21 +00:00
drh 2c8997b9a5 Disable synchronous writes to the master journal when PRAGMA synchronous=OFF 
for all database files.  Ticket #1375. (CVS 2630)

FossilOrigin-Name: 644b96aa23de7e828280d35785db840a4fa9413d
 2005-08-27 16:36:48 +00:00
drh 1c7880e501 Do not allow the pagesize of :memory: databases to be changed. Silently 
ignore PRAGMA page_size=N requests for :memory: databases.
Ticket #1144 and #1252. (CVS 2466)

FossilOrigin-Name: f29a1d882623d8ff14f35a302aef63a16388bcb3
 2005-05-20 20:01:55 +00:00
drh 4fb90f2bff Update comments and documentation to give the true maximum page size as 32K, 
not 64K as was previously (and erroneously) reported.  Ticket #1194. (CVS 2437)

FossilOrigin-Name: 58dd436b6572d38ea67960b8d08a0ca4359602f0
 2005-03-31 21:02:45 +00:00
danielk1977 6b456a2b46 Add function to recover from a malloc() failure. (CVS 2414) 
FossilOrigin-Name: 1f9d10d7965c95d1e35f64cf4c3f128adabd41f2
 2005-03-21 04:04:02 +00:00
drh 7bec505e26 Add the (highly experimental) omit_readlock pragma that disables the use 
of readlocks on read-only databases that are connected using ATTACH. (CVS 2317)

FossilOrigin-Name: 2155448d2128119f74241da0ea07d6713b71765c
 2005-02-06 02:45:41 +00:00
danielk1977 d761c0c9fd Do not truncate a database file until after fsync() has been called on the journal. (CVS 2068) 
FossilOrigin-Name: cfee7f4a004c5e57d58edcf9de3ded0a199940a3
 2004-11-05 16:37:02 +00:00
danielk1977 687566d786 Code to auto-vacuum the database if all root pages happen to be in the right place. Not active by default and largely untested. (CVS 2037) 
FossilOrigin-Name: d12481f09cbe51c7ea499bc22afec5de3af14ad4
 2004-11-02 12:56:41 +00:00
drh 684917c269 Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) 
FossilOrigin-Name: 81ff8107ad63113782cf5a9ba7a512496114ba08
 2004-10-05 02:41:42 +00:00
drh 90f5ecb39d Initial implementation of variable page sizes and the temp_store pragma. (CVS 1843) 
FossilOrigin-Name: 4cf6e9db757931aba2f300b7869305434d6f2d2b
 2004-07-22 01:19:35 +00:00
danielk1977 bc6ada4103 Fixes for compiler warnings. Also more coverage. (CVS 1775) 
FossilOrigin-Name: fa19c77bf045787faa4cdc40bcfbd9eeae8594ae
 2004-06-30 08:20:16 +00:00
danielk1977 40b38dcdf8 Remove the 'nMaster' argument from various pager and btree functions. (CVS 1737) 
FossilOrigin-Name: 4e20720984e1fd6822ead785d758374d2704b7fb
 2004-06-26 08:38:24 +00:00
danielk1977 5865e3d54f Ensure the master journal directory is synced. Also, change the master journal 
format to store journal file names. (CVS 1583)

FossilOrigin-Name: 73cd0aabb24f7b663c8b55cf5e8fcb34fd48c032
 2004-06-14 06:03:57 +00:00
drh a6abd04193 Fixes to the file locking. 109 tests are now failing. (CVS 1548) 
FossilOrigin-Name: dc0763455bbf54c1d8728e16033709caedd6e1c6
 2004-06-09 17:37:22 +00:00
drh 89ac8c1a70 Add the "lock_status" pragma - only available when SQLITE_DEBUG is defined. 
Used for testing only. (CVS 1547)

FossilOrigin-Name: 0ecbba78fcde8f7715cd74c674b5040ef4953f6e
 2004-06-09 14:17:20 +00:00
danielk1977 24162fe668 Move the 'busy-callback' logic to the pager layer. (CVS 1527) 
FossilOrigin-Name: ff70b6d2b60c143e3ada0606ceff97571998c7e3
 2004-06-04 06:22:00 +00:00
danielk1977 13adf8a071 Untested updates to support atomic multi-file transactions (CVS 1526) 
FossilOrigin-Name: d57e5252c8baaf615c2cd218a33356ea5d95a5e2
 2004-06-03 16:08:41 +00:00
drh b6f4148607 Changes to btree and pager in preparation for moving to run-time page 
size determination. (CVS 1374)

FossilOrigin-Name: f63fb6dd4e8e33d4c1983396b1a0305836ee4df7
 2004-05-14 01:58:11 +00:00
danielk1977 4adee20fcb Change lots of internal symbols from sqliteXXX to sqlite3XXX so that the 
library links again. It doesn't work yet, due to changes in the btree layer
calling convention. (CVS 1324)

FossilOrigin-Name: 8af6474c49263ae26216dff9465b33f76b500cf4
 2004-05-08 08:23:19 +00:00
drh 3aac2dd7bc Pager tests working. (CVS 1308) 
FossilOrigin-Name: 910067a200c4b25b5d813a84146673d3d1c80952
 2004-04-26 14:10:20 +00:00
drh 9eb9e26b82 Pass all (relevant) regression tests when using the codec. (CVS 1223) 
FossilOrigin-Name: 5200e9edc5fdba0285a3cb1cd808cbf66d7a349e
 2004-02-11 02:18:05 +00:00
drh d0ba193dc7 Allow SQLITE_PAGE_SIZE to be redefined on the compiler command-line. (CVS 1217) 
FossilOrigin-Name: 4c7bf714b5f3d2bb7366367ddf906141a7e36407
 2004-02-10 01:54:28 +00:00
drh b20ea9d225 Add an optional codec to the pager layer. (CVS 1214) 
FossilOrigin-Name: 2f0c122cfb84dea58d112324a0bdd8b85552a9fa
 2004-02-09 01:20:36 +00:00
drh f7c5753174 Make VACUUM work even if multiple processes have the database open at once. (CVS 933) 
FossilOrigin-Name: caa960289f3d1f5e8f35a94e9e4321996c211ed2
 2003-04-25 13:22:51 +00:00
drh 73509eee84 Simplify the BTree interface by shortening names. Added two new methods 
for accessing the current filename and for changing the name of the
database file. (CVS 900)

FossilOrigin-Name: 185d8dc8d0c26cef36aeba6992823e5124af4056
 2003-04-06 20:44:45 +00:00
drh 001bbcbb8f Modifications to the VDBE to support more than one database file. (CVS 878) 
FossilOrigin-Name: 875da9eed981bfa27b98e95025f9fdbed74b4098
 2003-03-19 03:14:00 +00:00
drh 973b6e333d Added the new FULL option to the SYNCHRONOUS pragma. Still need to test it. (CVS 863) 
FossilOrigin-Name: 792a9e157dd066fcaffd4f5b373010151fb4ca61
 2003-02-12 14:09:42 +00:00
drh 968af52acf Modify the journal format to be more robust against garbage that might appear 
in the file after a power failure.  The changes are mostly working but more
testing is still required.  This check-in is to checkpoint the changes so far. (CVS 861)

FossilOrigin-Name: 8ec5632536eea31197a3b1fd6abc57881a0cf1d7
 2003-02-11 14:55:40 +00:00
drh da47d7748f Change to the pager to avoid opening journal files unnecessarily. This can 
sometimes results in a significant speed improvement. (CVS 791)

FossilOrigin-Name: fa5c042585c601449ede7319d0c5993cd8ba75a4
 2002-12-02 04:25:19 +00:00
drh 94f3331a0b Fix for ticket #9 (again). The rollback journal files should now also be 
byte-order independent. (CVS 705)

FossilOrigin-Name: 2fb3fdcdf06c1206bf14da640c2f9e599455f0eb
 2002-08-12 12:29:56 +00:00
drh 4b845d7ef4 Change the pager locking mechanism so that we don't have to write page 1 
to the journal and to the database unless it actually changes. (CVS 419)

FossilOrigin-Name: 480eef1a3a4f049bc0d0cbee32dc8a8d138597c6
 2002-03-05 12:41:19 +00:00
drh 30e58750c1 Pager optimization: do not write or journal free pages. This results in 
a 2x performance gain for large INSERTs and a 5x performance gain for
large DELETEs. (CVS 410)

FossilOrigin-Name: cf1ebcfb741786f84a596c406f4c492f68cbe881
 2002-03-02 20:41:57 +00:00
drh fa86c4127d Checkpoint code added to the pager. Regression tests work but the new APIs 
have not been tested yet. (CVS 361)

FossilOrigin-Name: aaa53e113ef849e34883ead8ae584c722ad967db
 2002-02-02 15:01:15 +00:00
drh 6446c4dc67 Comment and documentation changes. (CVS 331) 
FossilOrigin-Name: e8595579a5218aa3f344f967a23ac52ea89daca1
 2001-12-15 14:22:18 +00:00
drh 58a11680d1 Comment changes (CVS 308) 
FossilOrigin-Name: 2d2ad264aad6fbdcef586e73d750e3fde842252f
 2001-11-10 13:51:08 +00:00
drh b19a2bc603 Disclaimed copyright. Preparing for release 2.0. (CVS 250) 
FossilOrigin-Name: 4e926efe2b59adfec4086eb1d2ba830238facb4c
 2001-09-16 00:13:26 +00:00
drh 092d0350d5 Limit the total data in a single row to 2^16-1 bytes. (CVS 248) 
FossilOrigin-Name: 8fdec4d8b6043471f21235bc8918c9a8d838f508
 2001-09-15 13:15:12 +00:00
drh f57b14a657 Added a PRAGMA statement. Took out the special comment parsing. (CVS 245) 
FossilOrigin-Name: 5e3724603e6f52bb74deb1c62e6e8f323d7b64b7
 2001-09-14 18:54:08 +00:00