| # |
Type |
Status |
Created |
By |
Subsys |
Changed |
Assigned |
Svr |
Pri |
Title |
| 651 |
new
|
active
|
2004 Mar
|
anonymous
|
|
2009 Aug
|
|
5
|
4
|
Update optimization
|
| 1262 |
new
|
active
|
2005 May
|
anonymous
|
VDBE
|
2005 May
|
|
5
|
3
|
5-15% performance increase for slow joins
|
| 2853 |
new
|
active
|
2007 Dec
|
anonymous
|
|
2008 Jan
|
|
2
|
3
|
optimizer fails to use an index on MAX subquery
|
| 3058 |
new
|
active
|
2008 Apr
|
anonymous
|
|
2008 Apr
|
|
3
|
5
|
optimizer chooses wrong indicies
|
| 3140 |
new
|
active
|
2008 May
|
anonymous
|
|
2008 May
|
|
4
|
3
|
[PATCH] Make the default FTS3 tokenizer UTF8-aware
|
| 3285 |
new
|
active
|
2008 Aug
|
anonymous
|
|
2008 Aug
|
drh
|
5
|
5
|
Add a module_list pragma to display all modules installed
|
| 3303 |
new
|
active
|
2008 Aug
|
anonymous
|
|
2008 Aug
|
|
3
|
3
|
faster index creation for large tables
|
| 3330 |
new
|
active
|
2008 Aug
|
anonymous
|
|
2008 Aug
|
|
3
|
4
|
faster large updates
|
| 3639 |
new
|
active
|
2009 Feb
|
anonymous
|
vfs
|
2009 Feb
|
|
3
|
1
|
Syntax error doesn't report a line number
|
| 3647 |
new
|
active
|
2009 Feb
|
anonymous
|
front
|
2009 Feb
|
|
4
|
3
|
parsing natural join over more than 2 tables is too inefficient
|
| 3670 |
new
|
active
|
2009 Feb
|
anonymous
|
cli
|
2009 Feb
|
|
5
|
3
|
Shell: The "backup_timeout" method for backup/restore operations
|
| 3678 |
new
|
active
|
2009 Feb
|
anonymous
|
front
|
2009 Mar
|
|
3
|
5
|
index not selected with re-ordered distinct columns
|
| 3708 |
new
|
active
|
2009 Mar
|
anonymous
|
|
2009 Mar
|
|
3
|
4
|
UNION + ORDER BY
|
| 3742 |
new
|
active
|
2009 Mar
|
aswift
|
|
2009 Mar
|
drh
|
3
|
4
|
Performance improvements for common ORDER BY clauses
|
| 3749 |
new
|
active
|
2009 Mar
|
anonymous
|
|
2009 Mar
|
|
5
|
4
|
Condition for indexes
|
| 3998 |
new
|
active
|
2009 Jul
|
anonymous
|
func
|
2009 Aug
|
|
3
|
3
|
Optimization for UPDATE statement
|
| 4008 |
new
|
active
|
2009 Aug
|
anonymous
|
func
|
2009 Aug
|
|
1
|
1
|
2-digit year number in strftime() function by new 'y' switch
|