0056353: Reporting: performance issue in two standard reports

Notes
(0168716) frank_gonzalez (developer) 2024-09-04 07:58	Jira: https://openbravo.atlassian.net/browse/RM-16735 [^]

(0169297) ludmila_ursu (developer) 2024-09-17 22:46 edited on: 2024-09-17 22:47	https://docs.google.com/document/d/1scfjt7vJWqwkMEVHvCIOFkbyj89w8RtqMk3cyQkzkIk/editConnect [^] your Google account These topics are concerned by the 2 queries: “Rapport Flash - Topic” and “Acomptes_New” AHV and reports need to be recreated - Rapport Flash (Simple) - Rapport Flash Simple - 30 minutes - Suivi des Acomptes

(0169423) ludmila_ursu (developer) 2024-09-20 11:30	Hello, We can add the suggested indexes, and retest performance gain in produnit server. For this, we need the customer confirmation when the intervention can be done (max 1 hour, only the reporting server will not be available). For applying the other changes, the topics/ahv/reports need to be recreated. Please create a new jira for this.

(0169629) ludmila_ursu (developer) 2024-09-26 10:50 edited on: 2024-09-26 14:51	Indexes were added by Miguel Angel yesterday in produnit. Based on explain analyze, we see an improve of performance (results are present in the google sheet): - first query -> from 2 to 6 times faster - second query -> from 5 to 10 times faster. Given these results, the second query does no longer need modification. If needed, the first query can be simplified, to have an even better performance. For this, topic should be modified and AHV/reports should be recreated. Please create a new issue if this is needed. Indexes added in produnit (to be added also in production, when confirmed by the customer): CREATE INDEX obrts_inoutline_movdate_idx ON obrts_inoutline ((movementdate::date)); CREATE INDEX obrts_paydet_docdate_idx ON obrts_payment_details ((documentdate::date)); CREATE INDEX obrts_inoutline_so_movdate_idx ON obrts_inoutline_so ((movementdate::date)); CREATE INDEX obrts_ord_mv_created_idx ON obrts_order_data_mv ((created::date)); CREATE INDEX obrts_ord_mv_org_id_idx ON obrts_order_data_mv (obrtmd_org_id); CREATE INDEX obrts_ord_mv_docno_idx ON obrts_order_data_mv (documentno);

(0169755) ludmila_ursu (developer) 2024-09-30 12:27	MR for adding indexes: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.sales/-/merge_requests/59 [^]

Issue History
Date Modified	Username	Field	Change
2024-09-03 17:45	malsasua	New Issue
2024-09-03 17:45	malsasua	Assigned To	=> Triage Omni OMS
2024-09-03 17:45	malsasua	Modules	=> Core
2024-09-03 17:45	malsasua	Triggers an Emergency Pack	=> No
2024-09-04 07:58	frank_gonzalez	Note Added: 0168716
2024-09-04 07:58	frank_gonzalez	Assigned To	Triage Omni OMS => kousalya_r
2024-09-04 08:00	mtaal	Assigned To	kousalya_r => Triage Omni WMS
2024-09-16 09:13	mtaal	Assigned To	Triage Omni WMS => ludmila_ursu
2024-09-17 22:46	ludmila_ursu	Note Added: 0169297
2024-09-17 22:47	ludmila_ursu	Note Edited: 0169297	View Revisions
2024-09-20 11:30	ludmila_ursu	Note Added: 0169423
2024-09-20 11:31	ludmila_ursu	Status	new => feedback
2024-09-26 10:50	ludmila_ursu	Note Added: 0169629
2024-09-26 10:52	ludmila_ursu	Note Edited: 0169629	View Revisions
2024-09-26 14:51	ludmila_ursu	Note Edited: 0169629	View Revisions
2024-09-30 12:27	ludmila_ursu	Note Added: 0169755
2024-09-30 12:27	ludmila_ursu	Status	feedback => scheduled
2024-09-30 12:28	ludmila_ursu	Status	scheduled => resolved
2024-09-30 12:28	ludmila_ursu	Fixed in SCM revision	=> .
2024-09-30 12:28	ludmila_ursu	Resolution	open => fixed
2024-09-30 12:28	ludmila_ursu	Status	resolved => closed

Relationships [ Relation Graph ] [ Dependency Graph ]