Fossil SCM
Try to suppress an SQLite scan warning on servers for repositories with a large number of shunned or private artifacts.
Commit
85dd55db660a4338f5c696e99df91da1d7b7d69567ddd9c211c7cab00b5b8766
Parent
19c60b7fc9e2400…
1 file changed
+1
-1
+1
-1
| --- src/xfer.c | ||
| +++ src/xfer.c | ||
| @@ -972,11 +972,11 @@ | ||
| 972 | 972 | " ORDER BY blob.rid DESC", |
| 973 | 973 | pXfer->resync |
| 974 | 974 | ); |
| 975 | 975 | }else{ |
| 976 | 976 | db_prepare(&q, |
| 977 | - "SELECT uuid FROM unclustered JOIN blob USING(rid)" | |
| 977 | + "SELECT uuid FROM unclustered JOIN blob USING(rid) /*scan*/" | |
| 978 | 978 | " WHERE NOT EXISTS(SELECT 1 FROM shun WHERE uuid=blob.uuid)" |
| 979 | 979 | " AND NOT EXISTS(SELECT 1 FROM phantom WHERE rid=blob.rid)" |
| 980 | 980 | " AND NOT EXISTS(SELECT 1 FROM private WHERE rid=blob.rid)" |
| 981 | 981 | ); |
| 982 | 982 | } |
| 983 | 983 |
| --- src/xfer.c | |
| +++ src/xfer.c | |
| @@ -972,11 +972,11 @@ | |
| 972 | " ORDER BY blob.rid DESC", |
| 973 | pXfer->resync |
| 974 | ); |
| 975 | }else{ |
| 976 | db_prepare(&q, |
| 977 | "SELECT uuid FROM unclustered JOIN blob USING(rid)" |
| 978 | " WHERE NOT EXISTS(SELECT 1 FROM shun WHERE uuid=blob.uuid)" |
| 979 | " AND NOT EXISTS(SELECT 1 FROM phantom WHERE rid=blob.rid)" |
| 980 | " AND NOT EXISTS(SELECT 1 FROM private WHERE rid=blob.rid)" |
| 981 | ); |
| 982 | } |
| 983 |
| --- src/xfer.c | |
| +++ src/xfer.c | |
| @@ -972,11 +972,11 @@ | |
| 972 | " ORDER BY blob.rid DESC", |
| 973 | pXfer->resync |
| 974 | ); |
| 975 | }else{ |
| 976 | db_prepare(&q, |
| 977 | "SELECT uuid FROM unclustered JOIN blob USING(rid) /*scan*/" |
| 978 | " WHERE NOT EXISTS(SELECT 1 FROM shun WHERE uuid=blob.uuid)" |
| 979 | " AND NOT EXISTS(SELECT 1 FROM phantom WHERE rid=blob.rid)" |
| 980 | " AND NOT EXISTS(SELECT 1 FROM private WHERE rid=blob.rid)" |
| 981 | ); |
| 982 | } |
| 983 |