Fossil SCM
Give SQLite a hint to help it run faster in symbolic_name_to_rid().
Commit
d45542ccd2cf735ed476c051128c25a42cfe9bc0dd19e257526052708673da9f
Parent
50ed560c6bf8a97…
1 file changed
+1
-1
+1
-1
| --- src/name.c | ||
| +++ src/name.c | ||
| @@ -380,11 +380,11 @@ | ||
| 380 | 380 | if( zType[0]=='*' ){ |
| 381 | 381 | db_prepare(&q, "SELECT rid FROM blob WHERE uuid GLOB '%q*'", zUuid); |
| 382 | 382 | }else{ |
| 383 | 383 | db_prepare(&q, |
| 384 | 384 | "SELECT blob.rid" |
| 385 | - " FROM blob, event" | |
| 385 | + " FROM blob CROSS JOIN event" | |
| 386 | 386 | " WHERE blob.uuid GLOB '%q*'" |
| 387 | 387 | " AND event.objid=blob.rid" |
| 388 | 388 | " AND event.type GLOB '%q'", |
| 389 | 389 | zUuid, zType |
| 390 | 390 | ); |
| 391 | 391 |
| --- src/name.c | |
| +++ src/name.c | |
| @@ -380,11 +380,11 @@ | |
| 380 | if( zType[0]=='*' ){ |
| 381 | db_prepare(&q, "SELECT rid FROM blob WHERE uuid GLOB '%q*'", zUuid); |
| 382 | }else{ |
| 383 | db_prepare(&q, |
| 384 | "SELECT blob.rid" |
| 385 | " FROM blob, event" |
| 386 | " WHERE blob.uuid GLOB '%q*'" |
| 387 | " AND event.objid=blob.rid" |
| 388 | " AND event.type GLOB '%q'", |
| 389 | zUuid, zType |
| 390 | ); |
| 391 |
| --- src/name.c | |
| +++ src/name.c | |
| @@ -380,11 +380,11 @@ | |
| 380 | if( zType[0]=='*' ){ |
| 381 | db_prepare(&q, "SELECT rid FROM blob WHERE uuid GLOB '%q*'", zUuid); |
| 382 | }else{ |
| 383 | db_prepare(&q, |
| 384 | "SELECT blob.rid" |
| 385 | " FROM blob CROSS JOIN event" |
| 386 | " WHERE blob.uuid GLOB '%q*'" |
| 387 | " AND event.objid=blob.rid" |
| 388 | " AND event.type GLOB '%q'", |
| 389 | zUuid, zType |
| 390 | ); |
| 391 |