Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
Cheshire-Cat, 6.0.3, 6.5.1
-
Untriaged
-
1
-
Unknown
Description
create index tx1 on `travel-sample` (schedule);
|
select count(1) from `travel-sample` t where ANY v IN t.schedule SATISFIES v.flight LIKE "A%" END AND t.schedule IS NOT NULL; |
|
|
{
|
"requestID": "2edb8ee1-ab92-4901-afd4-f6441773721f", |
"signature": { |
"$1": "number" |
},
|
"results": [ |
{
|
"$1": 5348 |
}
|
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "794.997532ms", |
"executionTime": "794.945549ms", |
"resultCount": 1, |
"resultSize": 26 |
}
|
}
|
|
|
prepare p1 from select count(1) from `travel-sample` t where ANY v IN t.schedule SATISFIES v.flight LIKE $1 END AND t.schedule IS NOT NULL; |
\set -args ["A%"]; |
|
|
execute p1;
|
|
|
{
|
"requestID": "e980f556-9c46-4408-ae17-d402e2a06ea4", |
"signature": { |
"$1": "number" |
},
|
"results": [ |
{
|
"$1": 5348 |
}
|
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "3.749420749s", |
"executionTime": "3.749330119s", |
"resultCount": 1, |
"resultSize": 26 |
}
|
}
|
|
Same Plan only filter is difference 800ms vs 3.7secs
Attachments
Issue Links
Activity
| Field | Original Value | New Value |
|---|---|---|
| Summary | LIKE with query parameters very slow with inline | LIKE with query parameters slow vs inline |
Build couchbase-server-7.0.0-2704 contains query commit 888b97a with commit message:
MB-40648. cache compiled like when it is static
| Assignee | Kamini Jagtiani [ kamini.jagtiani ] | Sitaram Vemulapalli [ sitaram.vemulapalli ] |
| Summary | LIKE with query parameters slow vs inline | LIKE with query parameters 4x slow vs inline |
| Link | This issue is triggered by CBSE-8676 [ CBSE-8676 ] |
| Link | This issue blocks CBSE-8676 [ CBSE-8676 ] |
| Link | This issue blocks CBSE-8676 [ CBSE-8676 ] |
| Labels | 6.6.1-candidate |
| Link | This issue blocks MB-40528 [ MB-40528 ] |
| Labels | 6.6.1-candidate | approved-for-6.6.1 |
| Assignee | Sitaram Vemulapalli [ sitaram.vemulapalli ] | Mihir Kamdar [ mihir.kamdar ] |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Resolved [ 5 ] |
Build couchbase-server-6.6.1-9002 contains query commit e96315c with commit message:
MB-40648. cache compiled like when it is static
| Link | This issue blocks CBSE-8749 [ CBSE-8749 ] |
verified in 6.6.1-9089 and 7.0.0-3225, queries both take the same amount of time
| Status | Resolved [ 5 ] | Closed [ 6 ] |
| Fix Version/s | 7.0.0 [ 17233 ] |
| Fix Version/s | Cheshire-Cat [ 15915 ] |
We might be doing regular expression prefix evaluation every document when query parameter is there vs one time for constant . investigate and optimize.