0045091: Make grid timeout configurable from Grid Configuration

Description

Currently it is possible to configure grid timeout to prevent long queries to populate grids [1]. This is done in Openbravo.properties.

It has 2 limitations:
* It requires to restart the system after adapting it
* Grids for all tabs use the same config so it's not possible to specify different values per tab

[1] http://wiki.openbravo.com/wiki/How_to_Define_the_Timeout_of_a_Query [^]

Steps To Reproduce

Proposed Solution

Extend grid configuration [1] to include grid timeout both at system and tab levels.

Considerations:
1. Should we keep Openbravo.properties config or completely replace with the new config.
2. If we keep 1, we need to define the precedence in case both Openbravo.properties and grid config at system levels are defined
3. Grid config setting should be cached to prevent additional db queries to retrieve the values whenever data grid is fetched

[1] http://wiki.openbravo.com/wiki/User_Interface_Introduction#Grid_Configuration [^]

Tags

Performance

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2020-09-18 10:54	alostale	New Issue
2020-09-18 10:54	alostale	Assigned To	=> platform
2020-09-18 10:54	alostale	Modules	=> Core
2020-09-18 10:54	alostale	Triggers an Emergency Pack	=> No
2020-09-18 10:55	alostale	Proposed Solution updated
2020-09-18 10:57	alostale	Tag Attached: Performance
2020-09-18 10:57	alostale	Summary	Make grid time configurable from Grid Configuration => Make grid timeout configurable from Grid Configuration
2020-09-18 11:25	ngarcia	Issue Monitored: ngarcia
2022-02-01 08:07	alostale	Assigned To	platform => Triage Platform Base