0011451: Time response of query generated by WAD is very high

(0022084)
rafaroda (developer)
2009-11-23 08:16

Stefan,

Can you please comment on this Openbravo ERP 2.40 issue?

Thanks.

(0022100)
shuehner (administrator)
2009-11-23 11:21

According to the reporter i assume it is the same problem as in 10989 just in a different place. Some queries to not add the to_number function calls for id's. Which works in this case but can be quite slow, if the queried table contains many rows. Seems like the issue here is in some of the selectDef* methods generated by wad.
If this is the same issue as in 10989 then it concerns only 2.40 and only postgres.

(0022103)
rafaroda (developer)
2009-11-23 11:43

Thank you very much for your comments Stefan.

@networkb: 0010989 seems to have been fixed in Openbravo ERP 2.40 MP11. Please try to reproduce this issue there and inform about the result.

Thanks.

(0022144)
networkb (developer)
2009-11-24 19:05

i have applied the patch of 10989 ticket and the time is better in some queries, but to create new record in this window, the time is very high.

(0022158)
rafaroda (developer)
2009-11-25 10:08

Stefan, should we schedule this defect?

(0022712)
shuehner (administrator)
2009-12-11 16:22

Issue is only related to 2.40 and postgres >=8.3. Closing defect, 2.40 will be handled in the scheduled backport.

Issue History
Date Modified	Username	Field	Change
2009-11-20 20:32	networkb	New Issue
2009-11-20 20:32	networkb	Assigned To	=> rafaroda
2009-11-23 08:16	rafaroda	Note Added: 0022084
2009-11-23 08:16	rafaroda	Assigned To	rafaroda => shuehner
2009-11-23 10:29	shuehner	Relationship added	related to 0010989
2009-11-23 11:21	shuehner	Note Added: 0022100
2009-11-23 11:43	rafaroda	Note Added: 0022103
2009-11-23 11:43	rafaroda	Status	new => feedback
2009-11-23 13:13	rafaroda	Issue Monitored: rafaroda
2009-11-24 19:05	networkb	Note Added: 0022144
2009-11-25 10:08	rafaroda	Note Added: 0022158
2009-11-25 10:08	rafaroda	Status	feedback => new
2009-11-27 15:21	rafaroda	Priority	immediate => high
2009-11-27 15:21	rafaroda	Status	new => scheduled
2009-11-27 15:21	rafaroda	fix_in_branch	=> pi
2009-12-11 16:22	shuehner	Note Added: 0022712
2009-12-11 16:22	shuehner	Status	scheduled => closed
2009-12-11 16:22	shuehner	Resolution	open => no change required
2009-12-12 00:00	anonymous	sf_bug_id	0 => 2912998

Notes
(0022084) rafaroda (developer) 2009-11-23 08:16	Stefan, Can you please comment on this Openbravo ERP 2.40 issue? Thanks.

(0022100) shuehner (administrator) 2009-11-23 11:21	According to the reporter i assume it is the same problem as in 10989 just in a different place. Some queries to not add the to_number function calls for id's. Which works in this case but can be quite slow, if the queried table contains many rows. Seems like the issue here is in some of the selectDef* methods generated by wad. If this is the same issue as in 10989 then it concerns only 2.40 and only postgres.

(0022103) rafaroda (developer) 2009-11-23 11:43	Thank you very much for your comments Stefan. @networkb: 0010989 seems to have been fixed in Openbravo ERP 2.40 MP11. Please try to reproduce this issue there and inform about the result. Thanks.

(0022144) networkb (developer) 2009-11-24 19:05	i have applied the patch of 10989 ticket and the time is better in some queries, but to create new record in this window, the time is very high.

(0022158) rafaroda (developer) 2009-11-25 10:08	Stefan, should we schedule this defect?

(0022712) shuehner (administrator) 2009-12-11 16:22	Issue is only related to 2.40 and postgres >=8.3. Closing defect, 2.40 will be handled in the scheduled backport.