drop operation_id from the flow_unique_scope index
Open
@blizzz is already working on this.
Since Mar 26, 2025.
1. to develop
enhancement
feature: workflows
performance 🚀
- Dominant language
- PHP
- Stars
- 36.9k
- Forks
- 5.2k
- Avg merge
- 2d 3h
- Merged PRs (30d)
- 713
Description
Table "public.oc_flow_operations_scope"
Column | Type | Collation | Nullable | Default
--------------+-----------------------+-----------+----------+------------------------------------------------------
id | bigint | | not null | nextval('oc_flow_operations_scope_id_seq'::regclass)
operation_id | integer | | not null |
type | integer | | not null |
value | character varying(64) | | | NULL::character varying
Indexes:
"oc_flow_operations_scope_pkey" PRIMARY KEY, btree (id)
"flow_unique_scope" UNIQUE, btree (operation_id, type, value)
The operation_id shall be dropped from the flow_unique_scope index, as common queries only compare with type and value but not operation_id.
- verify that operation_id is not used in where clauses
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.