Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0011342Openbravo ERPA. Platformpublic2009-11-12 17:552009-11-19 00:00
shuehner 
shuehner 
normalmajorhave not tried
closedfixed 
5
pi 
 
Core
No
0011342: on excport.database/update.database: the part Checking if database structure was modified locally. takes very long on postgres
The 'Checking if database structure was modified locally.' part of update.database and export.database is really slow (15-30s)

No tags attached.
Issue History
2009-11-12 17:55shuehnerNew Issue
2009-11-12 17:55shuehnerAssigned To => shuehner
2009-11-12 17:56hgbotCheckin
2009-11-12 17:56hgbotNote Added: 0021787
2009-11-12 17:56hgbotStatusnew => resolved
2009-11-12 17:56hgbotResolutionopen => fixed
2009-11-12 17:56hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d399c012996eee5e3f7e20deb7624ad445a873cc [^]
2009-11-18 16:17marvintmNote Added: 0021975
2009-11-18 16:17marvintmStatusresolved => closed
2009-11-19 00:00anonymoussf_bug_id0 => 2900162

Notes
(0021787)
hgbot   
2009-11-12 17:56   
Repository: erp/devel/pi
Changeset: d399c012996eee5e3f7e20deb7624ad445a873cc
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Nov 12 17:56:20 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d399c012996eee5e3f7e20deb7624ad445a873cc [^]

Fixed 11342: Optimize 'Checking if db structure was modified' on postgres

---
M src-db/database/model/prescript-PostgreSql.sql
---
(0021975)
marvintm   
2009-11-18 16:17   
The new version of the function indeed runs much faster. I've looked at the changes in the source code for the function, and they seem correct.