/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

14 check-ins related to "view-optimization"

2015-06-11
17:58
Merge trunk fixes. Leaf check-in: 1df8cbbea6 user: drh tags: view-optimization
14:19
Remove stray outputs from the test suite. check-in: afc6db9b10 user: drh tags: trunk
2015-06-10
20:00
Merge enhancements from trunk. check-in: 0e23a079bd user: drh tags: view-optimization
18:53
"test" targets on all makefiles use --verbose=file --output=test-out.txt. Add the new "quicktest" target to all makefiles - designed to run in under three minutes. The --quick option on releasetest.tcl now uses quicktest. check-in: 6ddef2ad35 user: drh tags: trunk
17:20
Resolve FROM-clause subqueries after query planning instead of before. Greatly reduce the estimated cost of automatic indexes for VIEWs and ephemeral tables since performance problems there cannot be mitigated via a CREATE INDEX. check-in: a1eaf1718e user: drh tags: view-optimization
2015-06-08
22:59
Code refactoring to try to shift FROM-clause subquery manifesting until after the query planner runs. Except this does not currently work because the query planner needs an estimated of the number of rows in the manifested table. Work in progress. check-in: cabf218716 user: drh tags: view-optimization
17:40
Split out some source code into new files: wherecode.c, whereexpr.c, and treeview.c. Other minor refactoring changes. check-in: 50f336818c user: drh tags: trunk
15:08
Factor out the TreeView parse tree printing module into a separate file. check-in: c32ce54ca4 user: drh tags: view-optimization
14:23
Split more subfunctions of where.c out into a new whereexpr.c source file, for improved maintainability. check-in: 46ef95c108 user: drh tags: view-optimization
2015-06-06
20:12
Split out the bulk of the actual VDBE code generation logic from where.c into a new file, leaving behind the analysis logic. This makes the original where.c smaller and hopefully easier to edit. check-in: faa0e420e9 user: drh tags: view-optimization
18:30
Code simplifications in select.c and where.c. check-in: 4f20ac90bc user: drh tags: view-optimization
00:18
Minor cleanup of the sqlite3Select() procedure. check-in: f4c90d06bb user: drh tags: view-optimization
2015-06-05
22:33
Split FROM-clause subquery flattening and code generation into separate loops. check-in: be8e3fc70e user: drh tags: view-optimization
20:27
Provide one final Select tree dump prior to WHERE clause analysis when ".selecttrace 0x400" tracing bit is set with SELECTTRACE_ENABLED. Analysis and debug changes only - normal builds are unaffected. check-in: 283bf0b64d user: drh tags: trunk