Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0000562Openbravo ERP01. General setuppublic2008-06-06 12:232008-09-08 11:01
dnyaga 
cromero 
normalminoralways
closedout of date 
20Ubuntu 8.04
2.35MP4 
2.40 
Core
No
0000562: Deleting a client takes a very long time
I am working with OpenBravo 2.35 MP5 on Ubuntu 8.04. On my test machine (3 Ghz Intel Celeron, 2GB RAM, devoted entirely to Openbravo), the process of deleting a client - even one with no associated records - takes a very long time - well in excess of an hour. Postgresql CPU usage stays at approximately 90-95% for all this time.

This is an issue that I have encountered with prior versions of OpenBravo. In my inexpert assessment, it seems to be a part of a general problem with complex queries in postgresql.
In Postgresql 2.45MP5, create a new client. Then attempt to delete the client immediately.
No tags attached.
Issue History
2008-06-06 12:23dnyagaNew Issue
2008-06-06 12:23dnyagaAssigned To => cromero
2008-06-09 12:43psarobeStatusnew => scheduled
2008-06-09 17:13jaimetorreTarget Version => 2.50
2008-06-09 17:13jaimetorreTarget Version2.50 =>
2008-06-13 19:59cromeroTarget Version => 2.40
2008-06-21 22:44pjuvaraNote Added: 0007938
2008-06-21 22:44pjuvaraStatusscheduled => feedback
2008-07-01 17:56anonymoussf_bug_id0 => 2007931
2008-09-08 11:01psarobeRegression testing => No
2008-09-08 11:01psarobeStatusfeedback => closed
2008-09-08 11:01psarobeNote Added: 0008913
2008-09-08 11:01psarobeResolutionopen => out of date

Notes
(0007938)
pjuvara   
2008-06-21 22:44   
Performance tuning has been done for PostgreSQL in 2.40 alpha r3. Please verify if this bug still reproduces.
(0008913)
psarobe   
2008-09-08 11:01   
in Later releases has been fixed

Thanks