Fossil SCM
Minor performance optimizations on the /artifact_stats page.
Commit
c2cf7ea14130e6af85e0fce67c8bf4d713a1b66cdbd05d8dc96af388a384f4b5
Parent
ada305fbc0c2e1d…
1 file changed
+3
-4
+3
-4
| --- src/stat.c | ||
| +++ src/stat.c | ||
| @@ -670,19 +670,18 @@ | ||
| 670 | 670 | @ szExp, -- expanded, uncompressed size |
| 671 | 671 | @ szCmpr -- size as stored on disk |
| 672 | 672 | @ ); |
| 673 | 673 | @ INSERT INTO artstat(id,atype,isDelta,szExp,szCmpr) |
| 674 | 674 | @ SELECT blob.rid, NULL, |
| 675 | - @ EXISTS(SELECT 1 FROM delta WHERE delta.rid=blob.rid), | |
| 675 | + @ delta.rid IS NOT NULL, | |
| 676 | 676 | @ size, length(content) |
| 677 | - @ FROM blob | |
| 677 | + @ FROM blob LEFT JOIN delta ON blob.rid=delta.rid | |
| 678 | 678 | @ WHERE content IS NOT NULL; |
| 679 | 679 | ; |
| 680 | 680 | static const char zSql2[] = |
| 681 | 681 | @ UPDATE artstat SET atype='file' |
| 682 | - @ WHERE id IN (SELECT fid FROM mlink) | |
| 683 | - @ AND atype IS NULL; | |
| 682 | + @ WHERE +id IN (SELECT fid FROM mlink); | |
| 684 | 683 | @ UPDATE artstat SET atype='manifest' |
| 685 | 684 | @ WHERE id IN (SELECT objid FROM event WHERE type='ci') AND atype IS NULL; |
| 686 | 685 | @ UPDATE artstat SET atype='forum' |
| 687 | 686 | @ WHERE id IN (SELECT objid FROM event WHERE type='f') AND atype IS NULL; |
| 688 | 687 | @ UPDATE artstat SET atype='cluster' |
| 689 | 688 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -670,19 +670,18 @@ | |
| 670 | @ szExp, -- expanded, uncompressed size |
| 671 | @ szCmpr -- size as stored on disk |
| 672 | @ ); |
| 673 | @ INSERT INTO artstat(id,atype,isDelta,szExp,szCmpr) |
| 674 | @ SELECT blob.rid, NULL, |
| 675 | @ EXISTS(SELECT 1 FROM delta WHERE delta.rid=blob.rid), |
| 676 | @ size, length(content) |
| 677 | @ FROM blob |
| 678 | @ WHERE content IS NOT NULL; |
| 679 | ; |
| 680 | static const char zSql2[] = |
| 681 | @ UPDATE artstat SET atype='file' |
| 682 | @ WHERE id IN (SELECT fid FROM mlink) |
| 683 | @ AND atype IS NULL; |
| 684 | @ UPDATE artstat SET atype='manifest' |
| 685 | @ WHERE id IN (SELECT objid FROM event WHERE type='ci') AND atype IS NULL; |
| 686 | @ UPDATE artstat SET atype='forum' |
| 687 | @ WHERE id IN (SELECT objid FROM event WHERE type='f') AND atype IS NULL; |
| 688 | @ UPDATE artstat SET atype='cluster' |
| 689 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -670,19 +670,18 @@ | |
| 670 | @ szExp, -- expanded, uncompressed size |
| 671 | @ szCmpr -- size as stored on disk |
| 672 | @ ); |
| 673 | @ INSERT INTO artstat(id,atype,isDelta,szExp,szCmpr) |
| 674 | @ SELECT blob.rid, NULL, |
| 675 | @ delta.rid IS NOT NULL, |
| 676 | @ size, length(content) |
| 677 | @ FROM blob LEFT JOIN delta ON blob.rid=delta.rid |
| 678 | @ WHERE content IS NOT NULL; |
| 679 | ; |
| 680 | static const char zSql2[] = |
| 681 | @ UPDATE artstat SET atype='file' |
| 682 | @ WHERE +id IN (SELECT fid FROM mlink); |
| 683 | @ UPDATE artstat SET atype='manifest' |
| 684 | @ WHERE id IN (SELECT objid FROM event WHERE type='ci') AND atype IS NULL; |
| 685 | @ UPDATE artstat SET atype='forum' |
| 686 | @ WHERE id IN (SELECT objid FROM event WHERE type='f') AND atype IS NULL; |
| 687 | @ UPDATE artstat SET atype='cluster' |
| 688 |