0004155: Grid view results in very large number of db queries

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0004155

Openbravo ERP

B. User interface

public

2008-06-24 17:04

2008-10-08 18:41

Reporter

user71

Assigned To

gorka_gil

Priority

urgent

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

2.35MP7

Merge Request Status

Review Assigned To

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0004155: Grid view results in very large number of db queries

Description

OS: Linux - Suse 10.2 (test/prod) & Windows XP (dev)
DB: Postgres 8.1.5 (test/prod) & 8.2.4 (dev)
Release: 2.34
Browser: Firefox 2.0.0.6, IE 7

Actually noticed this one in an installation on an an old server. When viewing the Purchase Order grid each datagrid ajax request would take about 5 seconds. This often caused the grid not to display the data (I assume due to an ajax timeout).

The slowness is caused by the construction of the table sql. In the Purchase order case the structure comes back quickly then when creating the sql it goes off the db again many many times.

I was able to improve it significantly by only fetching the displayed columns/fields in the initial structure query. (which then cuts down on the the number of subsequent db requests).

After applying the attached patch the request time went down to less than a second. There is still lots of room for optimization but this helps a lot.

Steps To Reproduce

Proposed Solution

Additional Information