Fossil SCM
Slightly faster file-age query.
Commit
f953a1638b38fd4eb1eb8e5655d677ca56a9a3d681e3061843cf7d2f05caf665
Parent
3cd0b26414efb87…
1 file changed
+5
-6
+5
-6
| --- src/browse.c | ||
| +++ src/browse.c | ||
| @@ -957,16 +957,15 @@ | ||
| 957 | 957 | @ CREATE VIRTUAL TABLE IF NOT EXISTS temp.foci USING files_of_checkin; |
| 958 | 958 | ; |
| 959 | 959 | |
| 960 | 960 | static const char zComputeFileAgeRun[] = |
| 961 | 961 | @ WITH RECURSIVE |
| 962 | -@ ckin(x,m) AS (SELECT objid, mtime FROM event WHERE objid=:ckin | |
| 963 | -@ UNION | |
| 964 | -@ SELECT plink.pid, event.mtime | |
| 965 | -@ FROM ckin, plink, event | |
| 966 | -@ WHERE plink.cid=ckin.x AND event.objid=plink.pid | |
| 967 | -@ ORDER BY 2 DESC) | |
| 962 | +@ ckin(x) AS (VALUES(:ckin) | |
| 963 | +@ UNION | |
| 964 | +@ SELECT plink.pid | |
| 965 | +@ FROM ckin, plink | |
| 966 | +@ WHERE plink.cid=ckin.x) | |
| 968 | 967 | @ INSERT OR IGNORE INTO fileage(fnid, fid, mid, mtime, pathname) |
| 969 | 968 | @ SELECT filename.fnid, mlink.fid, mlink.mid, event.mtime, filename.name |
| 970 | 969 | @ FROM foci, filename, blob, mlink, event |
| 971 | 970 | @ WHERE foci.checkinID=:ckin |
| 972 | 971 | @ AND foci.filename GLOB :glob |
| 973 | 972 |
| --- src/browse.c | |
| +++ src/browse.c | |
| @@ -957,16 +957,15 @@ | |
| 957 | @ CREATE VIRTUAL TABLE IF NOT EXISTS temp.foci USING files_of_checkin; |
| 958 | ; |
| 959 | |
| 960 | static const char zComputeFileAgeRun[] = |
| 961 | @ WITH RECURSIVE |
| 962 | @ ckin(x,m) AS (SELECT objid, mtime FROM event WHERE objid=:ckin |
| 963 | @ UNION |
| 964 | @ SELECT plink.pid, event.mtime |
| 965 | @ FROM ckin, plink, event |
| 966 | @ WHERE plink.cid=ckin.x AND event.objid=plink.pid |
| 967 | @ ORDER BY 2 DESC) |
| 968 | @ INSERT OR IGNORE INTO fileage(fnid, fid, mid, mtime, pathname) |
| 969 | @ SELECT filename.fnid, mlink.fid, mlink.mid, event.mtime, filename.name |
| 970 | @ FROM foci, filename, blob, mlink, event |
| 971 | @ WHERE foci.checkinID=:ckin |
| 972 | @ AND foci.filename GLOB :glob |
| 973 |
| --- src/browse.c | |
| +++ src/browse.c | |
| @@ -957,16 +957,15 @@ | |
| 957 | @ CREATE VIRTUAL TABLE IF NOT EXISTS temp.foci USING files_of_checkin; |
| 958 | ; |
| 959 | |
| 960 | static const char zComputeFileAgeRun[] = |
| 961 | @ WITH RECURSIVE |
| 962 | @ ckin(x) AS (VALUES(:ckin) |
| 963 | @ UNION |
| 964 | @ SELECT plink.pid |
| 965 | @ FROM ckin, plink |
| 966 | @ WHERE plink.cid=ckin.x) |
| 967 | @ INSERT OR IGNORE INTO fileage(fnid, fid, mid, mtime, pathname) |
| 968 | @ SELECT filename.fnid, mlink.fid, mlink.mid, event.mtime, filename.name |
| 969 | @ FROM foci, filename, blob, mlink, event |
| 970 | @ WHERE foci.checkinID=:ckin |
| 971 | @ AND foci.filename GLOB :glob |
| 972 |