Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
146 check-ins going from cf3b8e32932aa0c5 to 4d7b8625726127ee
|
2009-04-21
| ||
| 07:51 | Performance and coverage improvements. check-in: 4d7b862572 user: dan tags: pager-refactor-1 | |
|
2009-04-20
| ||
| 18:57 | Performance improvements related to rowhash object. check-in: fa949adf0a user: dan tags: pager-refactor-1 | |
| 17:17 | Fix rowhash so that it never allocates more than ROWHASH_ALLOCATION bytes at a time. check-in: fc5af1cd42 user: dan tags: pager-refactor-1 | |
| 14:10 | Change the way the rowhash object works so that it is faster and uses less memory. check-in: eb74d8854f user: dan tags: pager-refactor-1 | |
|
2009-04-18
| ||
| 08:37 | Tests and performance enhancements related to rowhash object. check-in: 13be23282a user: dan tags: pager-refactor-1 | |
|
2009-04-17
| ||
| 16:41 | Add further tests (and a bugfix) for the RowHash structure. check-in: e57373100c user: dan tags: pager-refactor-1 | |
| 11:46 | Enable a disabled optimization in the OP_RowHash opcode. check-in: db286e6536 user: dan tags: pager-refactor-1 | |
| 11:09 | Regenerate the auto-generated part of where7.test with changes to account for the "ORDER BY rowid" change. check-in: a9e03d480e user: dan tags: pager-refactor-1 | |
| 11:07 | Have the OP_NotExists opcode clear the deferredMoveto flag on the cursor. check-in: 45c500c055 user: dan tags: pager-refactor-1 | |
| 09:48 | Modify the manually generated test cases in where7.test to account for the fact that an "ORDER BY rowid" is no longer optimized when scanning based on an 'OR' expression based in the WHERE clause. check-in: 1bfa4f3689 user: dan tags: pager-refactor-1 | |
| 09:34 | Fix a bug in rowhash.c. Also modify test cases to work with the new version of the OR optimizer. check-in: 84c4c59b05 user: dan tags: pager-refactor-1 | |
|
2009-04-16
| ||
| 19:00 | Avoid inserting into a row-hash object when running the scan for the final term in a list of OR connected terms. check-in: e8b7664b26 user: dan tags: pager-refactor-1 | |
| 18:17 | Fix some bugs and test cases associated with the OR expression processing. Still more to come. check-in: 4ace0177e2 user: dan tags: pager-refactor-1 | |
| 16:50 | Use a RowHash structure instead of a RowSet when optimizing OR expressions in the WHERE clause. There are still bugs. check-in: efc3e1a482 user: dan tags: pager-refactor-1 | |
| 10:32 | Add untested 'RowHash' structure. check-in: 4ca762a30c user: dan tags: pager-refactor-1 | |
|
2009-04-15
| ||
| 14:39 | First implementation of optimizing 'OR' terms in WHERE clauses when querying virtual tables. check-in: 0fe2ee0b3b user: dan tags: pager-refactor-1 | |
|
2009-04-13
| ||
| 16:19 | Sync with version 3.6.13 (cvs 6503). check-in: eedee0d6f0 user: dan tags: pager-refactor-1 | |
|
2009-03-18
| ||
| 11:02 | fix a couple of typos in assert statements. check-in: 6466d4eff9 user: dan tags: pager-refactor-1 | |
| 10:57 | Remove the BtreeCommitStmt and BtreeRollbackStmt APIs. Improve the comment above BtreeBeginStmt. check-in: c9a7bba690 user: dan tags: pager-refactor-1 | |
| 10:48 | Add an assert() statement. check-in: 7149a7304c user: dan tags: pager-refactor-1 | |
| 10:39 | Improve the code involved in the nested statement transaction change. Add further test cases. check-in: 3b35e0f018 user: dan tags: pager-refactor-1 | |
| 06:45 | Update to cvs 6354. check-in: b4fd7c3353 user: dan tags: pager-refactor-1 | |
| 06:39 | Sync with cvs 6354. check-in: 23238be0da user: dan tags: pager-refactor-1 | |
| 06:15 | Progress on nested statement transactions. check-in: 3f4833d852 user: dan tags: pager-refactor-1 | |
|
2009-03-17
| ||
| 11:06 | Add code for nested statement-transactions. Also update to cvs 6350. check-in: 50855d6d60 user: dan tags: pager-refactor-1 | |
|
2009-03-16
| ||
| 14:14 | Update to cvs 6347. check-in: 170e64d1a1 user: dan tags: pager-refactor-1 | |
|
2009-03-13
| ||
| 16:03 | Comment changes related to the sqlite3_unlock_notify() API. check-in: 205317edd4 user: dan tags: pager-refactor-1 | |
| 07:07 | Sync with cvs 6342. Also add multi-threaded test for unlock_notify() functionality. check-in: c4232bb20c user: dan tags: pager-refactor-1 | |
|
2009-03-10
| ||
| 17:40 | After a writer fails to obtain a write-lock on a shared-cache table, prevent any other connection from starting a new transaction on the shared-cache until either the writer or all existing readers have concluded their transactions. check-in: 8d64d9eb77 user: dan tags: pager-refactor-1 | |
| 12:32 | Add the SQLITE_LOCKED_SHAREDCACHE extended error code. check-in: 1c9f59b60f user: dan tags: pager-refactor-1 | |
|
2009-03-09
| ||
| 17:46 | Test cases to improve coverage of unlock-notify feature. check-in: f9a0ed5090 user: dan tags: pager-refactor-1 | |
|
2009-03-07
| ||
| 18:27 | Updates to unlock-notify feature code. check-in: 38a058e17d user: dan tags: pager-refactor-1 | |
|
2009-03-04
| ||
| 11:59 | Fix a couple of trivial test case issues introduced by the previous commit. check-in: 322472e089 user: dan tags: pager-refactor-1 | |
| 11:43 | Add [unlock_notify] method to tcl interface for testing sqlite3_unlock_notify. check-in: 71705797a1 user: dan tags: pager-refactor-1 | |
|
2009-03-03
| ||
| 19:09 | Untested code for unlock_notify() feature. check-in: 134492fd63 user: dan tags: pager-refactor-1 | |
|
2009-03-02
| ||
| 16:42 | Sync with cvs 6333. check-in: 1faaa4fde6 user: dan tags: pager-refactor-1 | |
|
2009-02-28
| ||
| 11:52 | Keep a list of triggers from the same database in Trigger.pTrigger. Only search the temp-schema for triggers on demand. This is a bit faster. check-in: a877d4f8bc user: dan tags: pager-refactor-1 | |
| 10:55 | Reduce the number of calls to sqlite3TriggerList(). check-in: 9fb95c4069 user: dan tags: pager-refactor-1 | |
|
2009-02-27
| ||
| 19:43 | Change the way triggers are stored to fix cvstrac ticket #3688. This might slow down the compiler in cases where there are many triggers in a single schema or temp schema. check-in: 71b7d40dc9 user: dan tags: pager-refactor-1 | |
| 19:36 | Update to cvs 6328. check-in: 10ac4f6aaf user: dan tags: pager-refactor-1 | |
|
2009-02-23
| ||
| 06:24 | Sync with 6312. check-in: 2828a7aae8 user: dan tags: pager-refactor-1 | |
|
2009-02-18
| ||
| 18:49 | Sync with cvs 6302. check-in: 14e282b5e3 user: dan tags: pager-refactor-1 | |
| 17:31 | Remove unused variable Vdbe.nCallback. Change sqlite3VdbeMakeReady() so that it does not allocate memory if a VM requires no memory-registers, SQL variables, VDBE cursors or space to marshal function arguments. check-in: c0cbd78d57 user: dan tags: pager-refactor-1 | |
| 13:11 | Remove some variables from struct Vdbe that had fallen out of use. check-in: 852adf3047 user: dan tags: pager-refactor-1 | |
| 12:53 | Changes to combine the allocation made for Vdbe.zSql and Vdbe.aOp[0].p4.z when SQLITE_OMIT_TRACE is not defined. check-in: 85055d8125 user: dan tags: pager-refactor-1 | |
| 11:51 | In sqlite3FinishCoding(), allocate Parse.nTab and Parse.nMem cursors and memory registers respectively, instead of Parse.nTab+3 and Parse.nMem+3. check-in: fe86e26e5a user: dan tags: pager-refactor-1 | |
|
2009-02-17
| ||
| 08:15 | Sync with cvs 6294. check-in: 09b91f6da8 user: dan tags: pager-refactor-1 | |
|
2009-02-16
| ||
| 19:21 | Fix a problem with the previous commit. Further tweaks to ExprDup(). check-in: 0435359dcf user: dan tags: pager-refactor-1 | |
| 17:44 | Further changes surrounding allocation of Expr. check-in: e957941108 user: dan tags: pager-refactor-1 | |
| 09:09 | Remove EP_xIsList and EP_Static flags. check-in: 272e05a400 user: dan tags: pager-refactor-1 | |
| 06:48 | Put Expr.pList and Expr.pSelect in a union to reduce the size of the Expr struct. check-in: d1bb6dd79a user: dan tags: pager-refactor-1 | |
|
2009-02-14
| ||
| 12:37 | Reduce the number of mallocs used to allocate schema functions by allocating multiple expression nodes using a single allocation. check-in: 4bef5d60f1 user: dan tags: pager-refactor-1 | |
| 10:01 | Further changes to reduce the size of Expr nodes stored as part of the in-memory schema. check-in: ff5dfb65bd user: dan tags: pager-refactor-1 | |
|
2009-02-13
| ||
| 20:04 | Changes to reduce the size of the in-memory schema. check-in: 13580d3c47 user: dan tags: pager-refactor-1 | |
|
2009-02-10
| ||
| 18:15 | Update to cvs 6277. check-in: fbcb5fad6c user: dan tags: pager-refactor-1 | |
|
2009-02-03
| ||
| 17:37 | Sync with cvs 6240. check-in: 831f8ac13e user: dan tags: pager-refactor-1 | |
| 17:32 | Combine sqlite3BtreeCopyFile() with the new backup code. check-in: e9e07d058c user: dan tags: pager-refactor-1 | |
| 13:10 | Clean up some comments etc. in backup.c. check-in: c5095d2f6d user: dan tags: pager-refactor-1 | |
| 12:20 | Fix a bug whereby copying a small database over a large database with a different page size could result in corruption following an IO error. check-in: 1779de8d19 user: dan tags: pager-refactor-1 | |
| 11:25 | Add new file backup.c to the amalgamation and autoconf build systems. check-in: ba5ba2bf53 user: dan tags: pager-refactor-1 | |
| 11:16 | Add a restriction on using in-memory databases as the destination of a backup op: The source must have the same page-size as the destination. check-in: 8699b2c06d user: dan tags: pager-refactor-1 | |
| 09:11 | Add documentation for backup APIs to sqlite.h.in. check-in: ed6e9bfee2 user: dan tags: pager-refactor-1 | |
|
2009-02-02
| ||
| 19:59 | Extra coverage testing for backup feature. And some bugfixes. check-in: 33cd7ac82f user: dan tags: pager-refactor-1 | |
| 16:36 | Force source and destination handles of a backup operation to be distinct. check-in: da2d8bae41 user: dan tags: pager-refactor-1 | |
| 15:31 | Add tests for SQLITE_BUSY and SQLITE_LOCKED conditions to backup API tests. check-in: b469f8bd50 user: dan tags: pager-refactor-1 | |
| 14:59 | Add OOM tests for backup feature. check-in: 6747857534 user: dan tags: pager-refactor-1 | |
| 13:06 | Add tests and fixes for IO error handling in the backup code. check-in: a5eff8b203 user: dan tags: pager-refactor-1 | |
|
2009-01-31
| ||
| 18:15 | Prevent the user from closing or detaching the source database during a backup operation. check-in: 1c625aa8b1 user: dan tags: pager-refactor-1 | |
| 16:29 | Bugfixes and test cases for backup APIs. Also, sync with cvs 6221. check-in: c3c4fe6a94 user: dan tags: pager-refactor-1 | |
| 11:12 | Incremental work on backup APIs. check-in: c4835b63cc user: dan tags: pager-refactor-1 | |
|
2009-01-30
| ||
| 20:03 | Add test for non-existant database names to the backup tests. check-in: b5383452fa user: dan tags: pager-refactor-1 | |
| 19:26 | Further progress on the backup API. check-in: 966340a94a user: dan tags: pager-refactor-1 | |
| 16:33 | Progress on proposed backup API. check-in: a798e2f396 user: dan tags: pager-refactor-1 | |
|
2009-01-28
| ||
| 18:24 | Sync with cvs 6211. check-in: 209f3a9339 user: dan tags: pager-refactor-1 | |
|
2009-01-20
| ||
| 11:58 | Sync with cvs 6195. check-in: 75e824dad2 user: dan tags: pager-refactor-1 | |
| 11:56 | Remove unused variable PCache.nMin. check-in: f6d2061daf user: dan tags: pager-refactor-1 | |
| 06:13 | Add all missing files from cvs, including those that were accidentally removed by [5892dc46]. check-in: 8f47c5c46e user: dan tags: pager-refactor-1 | |
| 06:12 | Modify comment in pager.c. check-in: 5892dc464f user: dan tags: pager-refactor-1 | |
|
2009-01-19
| ||
| 22:58 | Add missing source files to Dan's branch. check-in: 392e104077 user: drh tags: pager-refactor-1 | |
| 17:02 | Change the order of functions in pager.c to eliminate the need for any forward declarations. check-in: bd9bff30cd user: dan tags: pager-refactor-1 | |
| 16:42 | Fix a couple of problems revealed by running all.test. check-in: d1b8a10e61 user: dan tags: pager-refactor-1 | |
| 11:10 | Fix an assert failing in pager.c. check-in: f995060104 user: dan tags: pager-refactor-1 | |
| 09:46 | Fix a crash following a malloc failure in pager.c. check-in: d330ca93ce user: dan tags: pager-refactor-1 | |
| 06:58 | Improve comments in pager.c some more. check-in: 2966e98249 user: dan tags: pager-refactor-1 | |
|
2009-01-17
| ||
| 19:45 | Improve comments on PagerCommitPhaseTwo() and PagerRollback(). check-in: a4f34e2f6a user: dan tags: pager-refactor-1 | |
| 18:13 | Sync with cvs 6192. check-in: cc44f8723e user: dan tags: pager-refactor-1 | |
| 17:05 | Modify comments and structure of PagerCommitPhaseOne() and related functions to make it easier to follow. check-in: 57bfb72677 user: dan tags: pager-refactor-1 | |
| 12:03 | Comment only changes to pager.c. check-in: 194e015a9a user: dan tags: pager-refactor-1 | |
| 10:06 | Change the signature of sqlite3PagerBegin() so that the argument is a Pager*, nnot a DbPage*. check-in: 49968cb491 user: dan tags: pager-refactor-1 | |
| 09:51 | More changes to comments in pager.c. Also some trivial code rationalization. check-in: 8f0341ec7e user: dan tags: pager-refactor-1 | |
| 09:50 | Sync with cvs 6190. check-in: 69cccb6d5c user: dan tags: pager-refactor-1 | |
|
2009-01-16
| ||
| 19:52 | Modify comment on PagerAcquire(). check-in: ce6c7deb6f user: dan tags: pager-refactor-1 | |
| 18:39 | Change the header comment on pagerSharedLock(). check-in: a71c223c52 user: dan tags: pager-refactor-1 | |
| 18:00 | Update to cvs 6189. Other changes too. check-in: ff77f80d53 user: dan tags: pager-refactor-1 | |
| 13:29 | Further comment changes in pager.c. check-in: c018a14cd7 user: dan tags: pager-refactor-1 | |
| 08:34 | Change the sqlitePagerPagecount() API so that it does not take the pending-lock page into account. check-in: e9e033eb34 user: dan tags: pager-refactor-1 | |
| 07:10 | Modify some comments surrounding the Pager structure. check-in: b0d04c50a3 user: dan tags: pager-refactor-1 | |
| 07:10 | Sync with cvs 6185. check-in: 3174819ea1 user: dan tags: pager-refactor-1 | |
|
2009-01-15
| ||
| 20:17 | Pager.dbModified and Pager.dirtyCache are the same variable. Remove Pager.dirtyCache. check-in: 36189bfd89 user: dan tags: pager-refactor-1 | |
| 19:57 | Further changes to pager.c. check-in: f63468ffd7 user: dan tags: pager-refactor-1 | |
|
2009-01-14
| ||
| 19:40 | Further edits to pager.c. check-in: 141c3f651c user: dan tags: pager-refactor-1 | |
| 13:16 | Comments and other non-functional changes to pager.c source. check-in: 2656fd30a5 user: dan tags: pager-refactor-1 | |
| 09:26 | Remove the Pager.journalOpen boolean. It is just as easy to test (Pager.jfd->pMethods). Add the isOpen(sqlite3_file*) macro to make things easier on the eye. check-in: 07f0fa9cdd user: dan tags: pager-refactor-1 | |
| 08:41 | Remove unused class members Pager.mxPage and Pager.nPage. check-in: 4971471257 user: dan tags: pager-refactor-1 | |
| 06:59 | Fix comment above JOURNAL_SIZE_LIMIT in pager.h (comment related to DEFAULT_AUTOVACUUM). Also shuffle the function declarations in pager.h around a bit and add some short comments. check-in: 23af2d874d user: dan tags: pager-refactor-1 | |
| 06:10 | Omit unnecessary call to PagerWrite() from btree.c. check-in: 96608b5d35 user: dan tags: pager-refactor-1 | |
| 06:10 | Update to [6175] (version 3.6.9). check-in: 6c113e7724 user: dan tags: pager-refactor-1 | |
|
2009-01-12
| ||
| 19:03 | Remove file accidentally added. check-in: 0eaf213195 user: dan tags: pager-refactor-1 | |
| 18:59 | Fix minor problem in pager.c. Improve comments. check-in: bea65968de user: dan tags: pager-refactor-1 | |
| 18:06 | Fix test failure in filefmt.test. check-in: 95323ecdcc user: dan tags: pager-refactor-1 | |
| 17:45 | Move the Pager.pAlwaysRollback bitvec to the btree layer. It is now BtShared.pHasContent. check-in: 9ddf8c3cdf user: dan tags: pager-refactor-1 | |
| 16:16 | Experimental change to pager interface. check-in: 838287de55 user: dan tags: pager-refactor-1 | |
| 05:15 | Update to cvs [6168]. check-in: 0e36008cd1 user: dan tags: pager-refactor-1 | |
|
2008-12-17
| ||
| 18:29 | When rolling back a transaction savepoint, do not drop locks or delete the journal file (as is done when rolling back a transaction). check-in: 655255ded2 user: dan tags: pager-refactor-1 | |
| 12:50 | Extra test cases (and bug fixes) for the savepoint feature. check-in: 62437b186f user: dan tags: pager-refactor-1 | |
| 09:22 | Add some simple tests to demonstrate that simple savepoint cases work. check-in: 727f7d7593 user: dan tags: pager-refactor-1 | |
|
2008-12-16
| ||
| 19:25 | Sync with version 3.6.7 (commit [6032]). check-in: 4e7e157444 user: dan tags: pager-refactor-1 | |
| 19:21 | Fix a crash in pager.c revealed by malloc.test. check-in: ffe966d116 user: dan tags: pager-refactor-1 | |
| 19:14 | Further changes for savepoint. Still not actually working. check-in: fcb6909c63 user: dan tags: pager-refactor-1 | |
|
2008-12-15
| ||
| 19:46 | Further incremental changes for savepoint. check-in: daea32361c user: dan tags: pager-refactor-1 | |
| 19:17 | Begin adding savepoint functionality. Doesn't work yet. check-in: 65abdf16bd user: dan tags: pager-refactor-1 | |
|
2008-12-13
| ||
| 15:41 | Trivial changes to new fts3 functionality. check-in: 663580fc6e user: dan tags: pager-refactor-1 | |
| 12:43 | Add some extra tests for the new fts3 syntax. check-in: 749a2e103a user: dan tags: pager-refactor-1 | |
| 06:59 | Update to cvs [6024]. check-in: 4b1a3ee908 user: dan tags: pager-refactor-1 | |
| 06:51 | Add test cases and fixes to bring coverage of fts3_expr.c up to 100%. check-in: c13d04a2b2 user: dan tags: pager-refactor-1 | |
|
2008-12-12
| ||
| 15:22 | Add fts3_expr.h. check-in: c305ca8417 user: dan tags: pager-refactor-1 | |
| 13:00 | Update to cvs [6023]. Also commit new changes to fts3. check-in: 3571685e8f user: dan tags: pager-refactor-1 | |
|
2008-12-03
| ||
| 23:51 | Add some work on more complex fts3 expressions. check-in: 870fdeddd1 user: dan tags: pager-refactor-1 | |
|
2008-11-11
| ||
| 15:13 | Fix up comments and other details associated with cache refactoring. check-in: 64f82c00a6 user: dan tags: pager-refactor-1 | |
|
2008-11-10
| ||
| 19:53 | Fix subtle bugs in new cache. check-in: 15c5376342 user: dan tags: pager-refactor-1 | |
| 18:23 | Fix SQLITE_CHECK_PAGES. Work on performance bugs in the new cache system. check-in: 6bff7368db user: dan tags: pager-refactor-1 | |
| 05:47 | Add xInit() and xShutdown() methods to sqlite3_pcache. check-in: 6edd2d1a17 user: dan tags: pager-refactor-1 | |
|
2008-11-08
| ||
| 10:35 | Update to cvs [5869]. check-in: 94f7ead532 user: dan tags: pager-refactor-1 | |
| 09:54 | When choosing a dirty page to recycle, prefer a page that does not require a journal-sync over one that does. check-in: 15c5b9d4d8 user: dan tags: pager-refactor-1 | |
|
2008-11-07
| ||
| 20:04 | Change things so that the pluggable cache module doesn't have to deal with zeroing referenced pages when truncating. check-in: e9d6e238f2 user: dan tags: pager-refactor-1 | |
| 18:20 | Fix some bugs in the cache refactoring. quick.test passes now. check-in: b677d82dec user: dan tags: pager-refactor-1 | |
| 15:06 | More progress on pluggable caches. Not finished yet, but veryquick.test now passes. check-in: 76241e2585 user: dan tags: pager-refactor-1 | |
|
2008-11-06
| ||
| 13:59 | Progress on pluggable caches. veryquick.test now runs, but doesn't pass. check-in: 79a95f58fb user: dan tags: pager-refactor-1 | |
|
2008-11-05
| ||
| 20:01 | Some progress towards pluggable cache modules. Most things are broken now. check-in: a15aae9902 user: dan tags: pager-refactor-1 | |
|
2008-11-04
| ||
| 17:07 | Update to cvs (5862). check-in: c7d0b2e67a user: dan tags: pager-refactor-1 | |
|
2008-10-27
| ||
| 08:42 | Update to cvs version [5842]. check-in: 2d7a6f645b user: dan tags: pager-refactor-1 | |
|
2008-10-17
| ||
| 19:38 | Minor change to memjournal.c to make object code a few bytes smaller. check-in: 6bc3e56258 user: dan tags: pager-refactor-1 | |
| 18:45 | Add the memjournal.c file that should have gone in two commits ago. check-in: 798a14b0a2 user: dan tags: pager-refactor-1 | |
| 10:45 | Try modifying things so that in-memory databases use the same rollback journal code as other databases (with an in-memory journal). check-in: 0b2ffa2385 user: dan tags: pager-refactor-1 | |
|
2008-10-16
| ||
| 18:46 | Add "PRAGMA journal_mode=memory". check-in: 37815bc39b user: dan tags: pager-refactor-1 | |
|
2008-10-15
| ||
| 15:25 | Update to SQLite version 3.6.4. check-in: cf3b8e3293 user: drh tags: trunk | |