Fossil SCM
Use a faster query when checking for private artifacts.
Commit
25a6ba26a20182d15abbff1401981c6a5970518ecd1ee06038f0b66c7b68e3f7
Parent
40abd83957dc73a…
1 file changed
+1
-1
+1
-1
| --- src/export.c | ||
| +++ src/export.c | ||
| @@ -1561,11 +1561,11 @@ | ||
| 1561 | 1561 | "SELECT objid, mtime, blob.uuid FROM event, blob\n" |
| 1562 | 1562 | " WHERE type='ci'" |
| 1563 | 1563 | " AND mtime>coalesce((SELECT value FROM mconfig WHERE key='start'),0.0)" |
| 1564 | 1564 | " AND blob.rid=event.objid" |
| 1565 | 1565 | " AND blob.uuid NOT IN (SELECT uuid FROM mirror.mmark WHERE NOT isfile)" |
| 1566 | - " AND blob.rid NOT IN (SELECT rid FROM private);" | |
| 1566 | + " AND NOT EXISTS (SELECT 1 FROM private WHERE rid=blob.rid);" | |
| 1567 | 1567 | ); |
| 1568 | 1568 | nTotal = db_int(0, "SELECT count(*) FROM tomirror"); |
| 1569 | 1569 | if( nLimit<nTotal ){ |
| 1570 | 1570 | nTotal = nLimit; |
| 1571 | 1571 | }else if( nLimit>nTotal ){ |
| 1572 | 1572 |
| --- src/export.c | |
| +++ src/export.c | |
| @@ -1561,11 +1561,11 @@ | |
| 1561 | "SELECT objid, mtime, blob.uuid FROM event, blob\n" |
| 1562 | " WHERE type='ci'" |
| 1563 | " AND mtime>coalesce((SELECT value FROM mconfig WHERE key='start'),0.0)" |
| 1564 | " AND blob.rid=event.objid" |
| 1565 | " AND blob.uuid NOT IN (SELECT uuid FROM mirror.mmark WHERE NOT isfile)" |
| 1566 | " AND blob.rid NOT IN (SELECT rid FROM private);" |
| 1567 | ); |
| 1568 | nTotal = db_int(0, "SELECT count(*) FROM tomirror"); |
| 1569 | if( nLimit<nTotal ){ |
| 1570 | nTotal = nLimit; |
| 1571 | }else if( nLimit>nTotal ){ |
| 1572 |
| --- src/export.c | |
| +++ src/export.c | |
| @@ -1561,11 +1561,11 @@ | |
| 1561 | "SELECT objid, mtime, blob.uuid FROM event, blob\n" |
| 1562 | " WHERE type='ci'" |
| 1563 | " AND mtime>coalesce((SELECT value FROM mconfig WHERE key='start'),0.0)" |
| 1564 | " AND blob.rid=event.objid" |
| 1565 | " AND blob.uuid NOT IN (SELECT uuid FROM mirror.mmark WHERE NOT isfile)" |
| 1566 | " AND NOT EXISTS (SELECT 1 FROM private WHERE rid=blob.rid);" |
| 1567 | ); |
| 1568 | nTotal = db_int(0, "SELECT count(*) FROM tomirror"); |
| 1569 | if( nLimit<nTotal ){ |
| 1570 | nTotal = nLimit; |
| 1571 | }else if( nLimit>nTotal ){ |
| 1572 |