martinweiler opened a new issue, #1877: URL: https://github.com/apache/incubator-kie-issues/issues/1877
The User Tasks schema currently only defines PK on most tables, but no additional indexes. Additional indexes should be added to improve performance during process execution: ``` 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); ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
