diff options
| author | dan <dan@noemail.net> | 2012-08-06 18:50:11 +0000 |
|---|---|---|
| committer | dan <dan@noemail.net> | 2012-08-06 18:50:11 +0000 |
| commit | 428c218c90cce7bbff210a19ee01ecdc01511076 (patch) | |
| tree | 70a786e7696405b715daf18df4c858e25427a467 /src/analyze.c | |
| parent | 8c5287ec73659e982e593c339b92e6ea2f5ff3d1 (diff) | |
| download | sqlite-428c218c90cce7bbff210a19ee01ecdc01511076.tar.gz sqlite-428c218c90cce7bbff210a19ee01ecdc01511076.zip | |
When reusing pages as part of creating a new index, allocate the leaves from each free-list trunk page in ascending order, instead of trying to maximize localization for each individual allocation. This increases the chance that pages will be written to disk in ascending order by a large CREATE INDEX statement, improving overall performance.
FossilOrigin-Name: d045f8b2d44e388d8c4549ff02d4ca7eff4e2038
Diffstat (limited to 'src/analyze.c')
| -rw-r--r-- | src/analyze.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/analyze.c b/src/analyze.c index 810ed54d8..632fdc1ac 100644 --- a/src/analyze.c +++ b/src/analyze.c @@ -176,7 +176,7 @@ static void openStatTable( "CREATE TABLE %Q.%s(%s)", pDb->zName, zTab, aTable[i].zCols ); aRoot[i] = pParse->regRoot; - aCreateTbl[i] = 1; + aCreateTbl[i] = OPFLAG_P2ISREG; }else{ /* The table already exists. If zWhere is not NULL, delete all entries ** associated with the table zWhere. If zWhere is NULL, delete the |