This is an automated email from the ASF dual-hosted git repository.
pefernan pushed a commit to branch main
in repository
https://gitbox.apache.org/repos/asf/incubator-kie-kogito-runtimes.git
The following commit(s) were added to refs/heads/main by this push:
new a0c8b5abf7 [kie-issues#1877] Add additional indexes to User Tasks
schema to improve performance (#3862)
a0c8b5abf7 is described below
commit a0c8b5abf7b87025abe7b4e5869cabb59e5ccb73
Author: Martin Weiler <[email protected]>
AuthorDate: Fri Jul 11 03:11:57 2025 -0600
[kie-issues#1877] Add additional indexes to User Tasks schema to improve
performance (#3862)
---
.../V1.0.3__jBPM_user_tasks_additional_indexes.sql | 35 ++++++++++++++++++++++
.../V1.0.3__jBPM_user_tasks_additional_indexes.sql | 35 ++++++++++++++++++++++
2 files changed, 70 insertions(+)
diff --git
a/addons/common/jbpm-usertask-storage-jpa/src/main/resources/kie-flyway/db/user-tasks/h2/V1.0.3__jBPM_user_tasks_additional_indexes.sql
b/addons/common/jbpm-usertask-storage-jpa/src/main/resources/kie-flyway/db/user-tasks/h2/V1.0.3__jBPM_user_tasks_additional_indexes.sql
new file mode 100644
index 0000000000..644e4b4e81
--- /dev/null
+++
b/addons/common/jbpm-usertask-storage-jpa/src/main/resources/kie-flyway/db/user-tasks/h2/V1.0.3__jBPM_user_tasks_additional_indexes.sql
@@ -0,0 +1,35 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+create index if not exists idx_usertasks_tid on jbpm_user_tasks(user_task_id);
+create index if not exists idx_jbpm_user_tasks_deadline_tid on
jbpm_user_tasks_deadline(task_id);
+create index if not exists idx_jbpm_user_tasks_inputs_tid on
jbpm_user_tasks_inputs(task_id);
+create index if not exists idx_jbpm_user_tasks_outputs_tid on
jbpm_user_tasks_outputs(task_id);
+create index if not exists idx_jbpm_user_tasks_metadata_tid on
jbpm_user_tasks_metadata(task_id);
+create index if not exists idx_jbpm_user_tasks_admin_groups_tid on
jbpm_user_tasks_admin_groups(task_id);
+create index if not exists idx_jbpm_user_tasks_admin_groups_gid on
jbpm_user_tasks_admin_groups(group_id);
+create index if not exists idx_jbpm_user_tasks_admin_users_tid on
jbpm_user_tasks_admin_users(task_id);
+create index if not exists idx_jbpm_user_tasks_admin_users_uid on
jbpm_user_tasks_admin_users(user_id);
+create index if not exists idx_jbpm_user_tasks_attachments_tid on
jbpm_user_tasks_attachments(task_id);
+create index if not exists idx_jbpm_user_tasks_potential_groups_tid on
jbpm_user_tasks_potential_groups(task_id);
+create index if not exists idx_jbpm_user_tasks_potential_groups_gid on
jbpm_user_tasks_potential_groups(group_id);
+create index if not exists idx_jbpm_user_tasks_potential_users_tid on
jbpm_user_tasks_potential_users(task_id);
+create index if not exists idx_jbpm_user_tasks_potential_users_uid on
jbpm_user_tasks_potential_users(user_id);
+create index if not exists idx_jbpm_user_tasks_excluded_users_uid on
jbpm_user_tasks_excluded_users(user_id);
+create index if not exists idx_jbpm_user_tasks_excluded_users_tid on
jbpm_user_tasks_excluded_users(task_id);
diff --git
a/addons/common/jbpm-usertask-storage-jpa/src/main/resources/kie-flyway/db/user-tasks/postgresql/V1.0.3__jBPM_user_tasks_additional_indexes.sql
b/addons/common/jbpm-usertask-storage-jpa/src/main/resources/kie-flyway/db/user-tasks/postgresql/V1.0.3__jBPM_user_tasks_additional_indexes.sql
new file mode 100644
index 0000000000..644e4b4e81
--- /dev/null
+++
b/addons/common/jbpm-usertask-storage-jpa/src/main/resources/kie-flyway/db/user-tasks/postgresql/V1.0.3__jBPM_user_tasks_additional_indexes.sql
@@ -0,0 +1,35 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+create index if not exists idx_usertasks_tid on jbpm_user_tasks(user_task_id);
+create index if not exists idx_jbpm_user_tasks_deadline_tid on
jbpm_user_tasks_deadline(task_id);
+create index if not exists idx_jbpm_user_tasks_inputs_tid on
jbpm_user_tasks_inputs(task_id);
+create index if not exists idx_jbpm_user_tasks_outputs_tid on
jbpm_user_tasks_outputs(task_id);
+create index if not exists idx_jbpm_user_tasks_metadata_tid on
jbpm_user_tasks_metadata(task_id);
+create index if not exists idx_jbpm_user_tasks_admin_groups_tid on
jbpm_user_tasks_admin_groups(task_id);
+create index if not exists idx_jbpm_user_tasks_admin_groups_gid on
jbpm_user_tasks_admin_groups(group_id);
+create index if not exists idx_jbpm_user_tasks_admin_users_tid on
jbpm_user_tasks_admin_users(task_id);
+create index if not exists idx_jbpm_user_tasks_admin_users_uid on
jbpm_user_tasks_admin_users(user_id);
+create index if not exists idx_jbpm_user_tasks_attachments_tid on
jbpm_user_tasks_attachments(task_id);
+create index if not exists idx_jbpm_user_tasks_potential_groups_tid on
jbpm_user_tasks_potential_groups(task_id);
+create index if not exists idx_jbpm_user_tasks_potential_groups_gid on
jbpm_user_tasks_potential_groups(group_id);
+create index if not exists idx_jbpm_user_tasks_potential_users_tid on
jbpm_user_tasks_potential_users(task_id);
+create index if not exists idx_jbpm_user_tasks_potential_users_uid on
jbpm_user_tasks_potential_users(user_id);
+create index if not exists idx_jbpm_user_tasks_excluded_users_uid on
jbpm_user_tasks_excluded_users(user_id);
+create index if not exists idx_jbpm_user_tasks_excluded_users_tid on
jbpm_user_tasks_excluded_users(task_id);
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
