Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
46 check-ins
|
2007-12-03
| ||
| 18:13 | Allow column types (and therefore affinity types) on index-only table columns. Leaf check-in: 6a65c90436 user: dan tags: trunk | |
| 13:32 | Fix a bug in test file speed6.test. check-in: 13c4172705 user: dan tags: trunk | |
| 08:33 | Add a script to generate a performance report for index-only tables. check-in: c193f3c1f5 user: dan tags: trunk | |
|
2007-12-02
| ||
| 08:15 | Fix a vdbe stack leak in index-only table code. check-in: 09179afc2a user: dan tags: trunk | |
|
2007-11-29
| ||
| 11:31 | Add test script for the recent IN(...) changes. check-in: 0f3027ff37 user: dan tags: trunk | |
| 10:34 | Avoid opening a new cursor used for IN(SELECT rowid ...) queries each time the returned set is accessed. check-in: 1b71253eeb user: dan tags: trunk | |
| 10:10 | Further optimisations to the IN() logic. check-in: 85366a6d3a user: dan tags: trunk | |
| 08:16 | Further changes to use existing database structures in place of temp-tables for IN(SELECT ...) expressions. check-in: 53a3661623 user: dan tags: trunk | |
|
2007-11-28
| ||
| 19:08 | Try to find an existing table or index that can be used by the IN (...) operator before creating a temporary one. check-in: b39b983013 user: dan tags: trunk | |
| 15:33 | Add a script to test the performance implications of the previous commit. Leaf check-in: e2e54235c9 user: dan tags: trunk | |
| 11:02 | Modifications to use existing data structures to implement IN(...) in some cases. This still needs work. check-in: 4a7447c35c user: dan tags: trunk | |
|
2007-11-26
| ||
| 23:36 | Updated comments in mem4.c. check-in: d3843119b1 user: drh tags: trunk | |
| 23:06 | Add mem4.c - a memory allocator that attempts to satisfy page size memory allocation requests from memory obtained from mmap. Use -DSQLITE_MMAP_HEAP_SIZE=nnn to enable. check-in: 0eb6b7024d user: drh tags: trunk | |
| 18:23 | Add the persist_cache pragma. check-in: 30a1df7393 user: dan tags: trunk | |
| 12:06 | When scanning a table using an index, defer opening the corresponding table row for as long as possible (in case it turns out to be unnecessary). No tests for this yet, but there is some evidence in the existing tests that it is working. check-in: 3f7aee66af user: dan tags: trunk | |
|
2007-11-24
| ||
| 13:02 | Update the sqlite3_analyzer tools so that is works with a database containing index-only tables. check-in: 048fb19942 user: drh tags: trunk | |
| 04:34 | Test cases and a fix for the count-changes functionality and index-only tables. (Previous commit deals with OR FAIL constraint handling). check-in: 47833ab866 user: dan tags: trunk | |
| 03:48 | (no comment) check-in: b9978492f5 user: dan tags: trunk | |
|
2007-11-23
| ||
| 16:29 | Fix vacuum and the xfer-optimisation so that they work with index-only tables. check-in: e00214ced3 user: dan tags: trunk | |
| 14:32 | Fix the integrity-check so that it works in the presence of index-only tables. check-in: 70b651c16e user: dan tags: trunk | |
| 14:12 | Add some test cases to check that index-only tables work in auto-vacuum mode. check-in: 3926a57cc9 user: dan tags: trunk | |
| 11:54 | Disable CREATE TRIGGER on index-only tables. check-in: 5c8436fbb3 user: dan tags: trunk | |
| 11:37 | Fix a problem with DROP TABLE introduced in the previous commit. check-in: 88500eeea2 user: dan tags: trunk | |
| 10:49 | Disallow CREATE INDEX and ALTER TABLE on index-only tables. Allow DROP INDEX (but not DROP TABLE). Store the rootpage of the associated index in the rootpage column of sqlite_master for the index-only table entry so that shared-cache table locking works. check-in: b0ce5302ea user: dan tags: trunk | |
| 07:52 | Use 64-bits for the mtime value used by index-only tables. The database mtime is now stored persistently using two of the previously unused 32-bit meta values in the database header. check-in: d156605950 user: dan tags: trunk | |
| 07:31 | Add code to implement REINDEX on index-only tables. check-in: 2b1bc9818f user: dan tags: trunk | |
|
2007-11-22
| ||
| 14:17 | Use two cursors during a DELETE on an index-only table. One to do the scan and another to call OP_Delete with. check-in: 6bbf751abe user: dan tags: trunk | |
| 11:47 | Reenable test cases that were segfaulting earlier. check-in: 6e70374928 user: dan tags: trunk | |
| 11:25 | Back out some fifo related changes that are not required. check-in: b10b347fb3 user: dan tags: trunk | |
| 10:20 | Modifications so that duplicate records may be stored in index-only tables. check-in: 9ba966e5f1 user: dan tags: trunk | |
|
2007-11-21
| ||
| 17:29 | Use the rowid field at the end of index records in index-only tables to store the mtime value. check-in: a92e48566b user: dan tags: trunk | |
| 15:27 | Modify test case causing infinite loop in idxonly.test (bug still needs to be fixed, but remove the test case for now). check-in: 20e73618ae user: dan tags: trunk | |
| 14:36 | Progress on index-only tables. They are now created using the syntax "CREATE INDEX db.name(...)". check-in: 053147c9d9 user: dan tags: trunk | |
|
2007-11-20
| ||
| 16:53 | Further modifications towards "index-only" tables. check-in: 0a5eb4a5bf user: dan tags: trunk | |
|
2007-11-19
| ||
| 17:18 | Begin changes for index-only tables. Not very much done yet. check-in: 7149801c6b user: dan tags: trunk | |
| 08:23 | Include the headers for mmap() functionality before sqliteInt.h. This avoids problems on osx. check-in: cb45bb26fd user: dan tags: trunk | |
| 06:02 | Import sqlite changes up to commit [4548]. check-in: e06b75a0dd user: dan tags: trunk | |
|
2007-11-03
| ||
| 00:12 | Disable the pager2.test when the default page size is something different than 1024. check-in: b57963229a user: drh tags: trunk | |
|
2007-11-02
| ||
| 23:03 | The mmap allocator for 4096-byte allocations appears to be working. check-in: 97126b55b6 user: drh tags: trunk | |
| 20:22 | Discard pager cache lines as soon as their refcount drops to zero. check-in: b5cc2d827e user: drh tags: trunk | |
| 17:56 | Call the sqlite3_malloc_cachepage() and sqlite3_free_cachepage() interfaces for all cache page allocations. check-in: 29212fd9c7 user: drh tags: trunk | |
| 17:47 | Added test and debug versions of sqlite3_malloc_cachepage() and sqlite3_free_cachepage(). Used only for the pTmpSpace at this time. check-in: c60bc64e46 user: drh tags: trunk | |
| 17:31 | Rename files speed1-Nk.test to speed1-Nk.tcl so that they are not automatically run by quick.test. check-in: fdce226103 user: drh tags: trunk | |
| 17:28 | Back out CVS change 4495. Page cache pages are malloced separately now. The initial check-in was from CVS version 4522, BTW. check-in: c790fe258b user: drh tags: trunk | |
| 17:10 | Initial code check-in check-in: 71c8052e36 user: drh tags: trunk | |
| 17:04 | initial empty baseline check-in: 22ffceb915 user: drh tags: trunk | |