0051089: Slowness on some queries of the module - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0051089

Modules

French Fiscal

public

2022-12-09 17:26

2023-11-07 15:51

Reporter

egoitz

Assigned To

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

Support ticket

OBNetwork customer

Regression introduced in release

Summary

0051089: Slowness on some queries of the module

Description

The following query is slow on environment with huge volume of data

Steps To Reproduce

SELECT obpos_appl0_.EM_Obcfr_Isblockchained AS col_0_0_, coalesce(obcfrticke1_.Seqno, 0) AS col_1_0_, obcfrticke1_.Hash AS col_2_0_, '***' AS col_3_0_, ( SELECT coalesce(max(obcfr_bloc2_.Seqno), 0) FROM OBCFR_BlockchainIssue obcfr_bloc2_ WHERE obcfr_bloc2_.Entity = 'OBCFR_Ticket' AND coalesce(obcfr_bloc2_.Obpos_Applications_ID, obcfr_bloc2_.AD_Client_ID) = 'C5CBA19E2F6D492FBAD24041E7BC8286') AS col_4_0_ FROM OBPOS_APPLICATIONS obpos_appl0_ LEFT OUTER JOIN OBCFR_Ticket obcfrticke1_ ON obpos_appl0_.Obpos_Applications_ID = obcfrticke1_.Obpos_Applications_ID WHERE obpos_appl0_.Obpos_Applications_ID = 'C5CBA19E2F6D492FBAD24041E7BC8286' AND coalesce(obcfrticke1_.Seqno, 0) = coalesce(( SELECT max(obcfr_tick3_.Seqno) FROM OBCFR_Ticket obcfr_tick3_ WHERE obcfr_tick3_.Obpos_Applications_ID = 'C5CBA19E2F6D492FBAD24041E7BC8286'), 0);

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

has duplicate	defect	0049792		closed	egoitz	Openbravo Localizations	Some queries are slow, and read lot of information from disk on environment with millioins of transation.
has duplicate	defect	0052132		closed	francisco_ofarril	Modules	Query generates locks on node A of the database server.