0047331: Improve performance FrenchFiscalSecurityManager

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0047331

Modules

French Fiscal

public

2021-07-05 13:54

2023-11-15 10:03

Reporter

vmromanos

Assigned To

vmromanos

Priority

normal

Severity

minor

Reproducibility

have not tried

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

0047331: Improve performance FrenchFiscalSecurityManager

Description

In a HV environment the following queries have been detected as slow:

select distinct obcfr_tick0_.Obpos_Applications_ID as col_0_0_ from OBCFR_Ticket obcfr_tick0_ where obcfr_tick0_.AD_Client_ID=$1
select distinct obcfr_tick0_.Obpos_Applications_ID as col_0_0_ from OBCFR_TicketTax obcfr_tick0_ where obcfr_tick0_.AD_Client_ID=$1
select distinct obcfr_tick0_.Obpos_Applications_ID as col_0_0_ from OBCFR_TicketReprint obcfr_tick0_ where obcfr_tick0_.AD_Client_ID=$1
select distinct obcfr_term0_.Obpos_Applications_ID as col_0_0_ from OBCFR_TerminalMonitor obcfr_term0_ where obcfr_term0_.AD_Client_ID=$1
select distinct obcfr_tick0_.Obpos_Applications_ID as col_0_0_ from OBCFR_Ticket_AggDay obcfr_tick0_ where obcfr_tick0_.AD_Client_ID=$1
select distinct obcfr_tick0_.Obpos_Applications_ID as col_0_0_ from OBCFR_Ticket_AggMonth obcfr_tick0_ where obcfr_tick0_.AD_Client_ID=$1
select distinct obcfr_tick0_.Obpos_Applications_ID as col_0_0_ from OBCFR_Ticket_AggYear obcfr_tick0_ where obcfr_tick0_.AD_Client_ID=$1

These queries are related to the FrenchFiscalSecurityManager class

Steps To Reproduce

Proposed Solution

1. Create an index on [AD_CLIENT_ID, Obpos_Applications_ID] for each of the affected tables and see if there are improvements. Other alternative is to create an index over [Obpos_Applications_ID] and remove the filter over the AD_Client_ID in the queries.

2. Optionally, consider filtering by terminal's isBlockchained flag where applicable

Additional Information

Tags

NOR

Relationships

has duplicate	defect	0049691		closed	egoitz	Openbravo Localizations	Some queries are slow, and read lot of information from disk on environment with millioins of transation.
related to	defect	0053940		closed	vmromanos	Modules	Improve performance FrenchFiscalSecurityManager