Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000101Openbravo ERPA. Platformpublic2008-04-24 12:582008-07-01 17:56
Reportercromero 
Assigned Toiciordia 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version2.40Fixed in Version2.40alpha-r3 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0000101: Compilation slow in PostgreSQL
DescriptionWhen I compile in PostgreSQL, the WAD windows generation is much slower that in Oracle. For example:
* when I compile in Oracle, more than one window are generated each second meanwhile in POstgreSQL, one window can spend more than 3 seconds to be generated.
Steps To Reproduceant compile.complete in postgreSQL or better, just ant compile -Dtab=Purchase just for generate only the Purchase window.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-04-24 12:58cromeroNew Issue
2008-04-24 12:58cromeroStatusnew => @50@
2008-04-24 12:58cromeroAssigned To => alostale
2008-05-07 17:14pjuvaraAssigned Toalostale => iciordia
2008-05-07 17:14pjuvaraSeverityminor => major
2008-05-07 17:14pjuvaraStatus@50@ => @40@
2008-05-07 17:14pjuvaraTypefeature request => defect
2008-05-07 17:14pjuvaraversion2.40 =>
2008-05-27 09:38pjuvaraIssue Monitored: pjuvara
2008-06-02 10:19cromeroStatusacknowledged => scheduled
2008-06-04 15:30pjuvaraNote Added: 0000438
2008-06-05 19:42svnbotCheckin
2008-06-05 19:42svnbotNote Added: 0000448
2008-06-05 19:42svnbotStatusscheduled => resolved
2008-06-05 19:42svnbotResolutionopen => fixed
2008-06-05 19:42svnbotsvn_revision => 4858
2008-06-11 12:46cromeroTarget Version => 2.40
2008-06-11 14:33cromeroFixed in Version => 2.40alpha r3
2008-06-19 11:16plujanStatusresolved => closed
2008-07-01 17:56anonymoussf_bug_id0 => 2007860

Notes
(0000438)
pjuvara   
2008-06-04 15:30   
On Wed, Jun 4, 2008 at 1:49 PM, Pablo Sarobe <pablo.sarobe@openbravo.com> wrote:

    Hi,

    I have imported Spanish language using PostgreSQL and the result is:

    *Process import language: 51 minutes
    *Then you have to compile: 83 minutes

    Total time 2h30m

    Thinking that the installation in postgreQSL takes 93 minutes, the result is:

    Installation: 93 minutes
    Import language: 51 minutes
    Compile.complete: 83 minutes

    Important:

    -Remember that these steps are the first ones that anybody would do if they don't speak english

    -4h to get what we had in previous versions in 60 minutes. This is going to be a big problem with the Spanish community (of course with the rest of the people but Spanish language was included).

    -We can loose a lot of possible end users just for this. 4 hours is too much
(0000448)
svnbot   
2008-06-05 19:42   
Repository: openbravo
Revision: 4858
Author: marvintm
Date: 2008-06-05 19:42:17 +0200 (Thu, 05 Jun 2008)

fixed bug 0000101: Added immutable and stable parameters to pg functions in prescript

---
U trunk/src-db/database/model/prescript-PostgreSql.sql
---

https://dev.openbravo.com/websvn/openbravo/?rev=4858&sc=1 [^]