Openbravo Issue Tracking System - Modules | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0053940 | Modules | French Fiscal | public | 2023-11-15 10:03 | 2023-11-22 08:28 | |||||||
| Reporter | egoitz | |||||||||||
| Assigned To | vmromanos | |||||||||||
| Priority | normal | Severity | major | Reproducibility | always | |||||||
| Status | closed | Resolution | fixed | |||||||||
| Platform | OS | 5 | 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 | 0053940: Improve performance FrenchFiscalSecurityManager | |||||||||||
| Description | In a HV environment the following queries have been detected as slow and consuming lot of disk. 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 | Check databse staticstics of any big customers. that is affecting several customers. | |||||||||||
| Proposed Solution | The fixed on the issue 47331 are not enough. If the goal is to identify the terminals used for the localization,. a new flag should be defined on the terminal like used Y/N and do the query on the applicaitons table. | |||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| 2023-11-15 10:03 | egoitz | New Issue | ||||||||||
| 2023-11-15 10:03 | egoitz | Assigned To | => vmromanos | |||||||||
| 2023-11-15 10:03 | egoitz | Issue generated from | 0047331 | |||||||||
| 2023-11-15 10:03 | egoitz | Relationship added | related to 0047331 | |||||||||
| 2023-11-15 10:04 | egoitz | Assigned To | vmromanos => Triage Omni OMS | |||||||||
| 2023-11-17 09:58 | vmromanos | Status | new => scheduled | |||||||||
| 2023-11-17 09:58 | vmromanos | Assigned To | Triage Omni OMS => vmromanos | |||||||||
| 2023-11-17 10:00 | hgbot | Note Added: 0157269 | ||||||||||
| 2023-11-22 08:28 | hgbot | Note Added: 0157443 | ||||||||||
| 2023-11-22 08:28 | hgbot | Resolution | open => fixed | |||||||||
| 2023-11-22 08:28 | hgbot | Status | scheduled => closed | |||||||||
| 2023-11-22 08:28 | hgbot | Note Added: 0157444 | ||||||||||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||