Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0054196Openbravo ERP02. Master data managementpublic2023-12-21 21:032023-12-22 08:30
Reportersdossantos 
Assigned ToTriage Omni OMS 
PriorityhighSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0054196: When we delete data in bulk, it takes a long time
DescriptionWhen we do a data migration, for example, it takes a long time to eliminate Business Partners.
We propose a solution with adding the INDEX.
Steps To Reproduce1- Delete many business partner

Take a long time
Proposed SolutionMandatory
CREATE INDEX c_bpartner_bparent_id_idx ON public.c_bpartner USING btree (bpartner_parent_id);
CREATE INDEX c_bpartner_salesrep_id_idx ON public.c_bpartner USING btree (salesrep_id);
CREATE INDEX c_validcombination_bpartner_id_idx ON public.c_validcombination USING btree (c_bpartner_id);

Optional
CREATE INDEX bpartner_isemployee_temp ON public.c_bpartner USING btree (isemployee);

Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-12-21 21:03sdossantosNew Issue
2023-12-21 21:03sdossantosAssigned To => Triage Omni OMS
2023-12-21 21:03sdossantosModules => Core
2023-12-21 21:03sdossantosTriggers an Emergency Pack => No
2023-12-22 08:30PracticsIssue Monitored: Practics

There are no notes attached to this issue.