0026961: Extreme slowness when running "GL Posting by DB table" for FIN_Finacc_Transaction table

Issue History
Date Modified	Username	Field	Change
2014-06-27 14:12	maite	New Issue
2014-06-27 14:12	maite	Assigned To	=> dmiguelez
2014-06-27 14:12	maite	Modules	=> Core
2014-06-27 14:12	maite	Triggers an Emergency Pack	=> No
2014-06-27 14:13	maite	Assigned To	dmiguelez => jonalegriaesarte
2014-06-27 14:13	maite	Issue Monitored: networkb
2014-06-27 14:16	egoitz	Note Added: 0068409
2014-06-30 13:42	jonalegriaesarte	Resolution time	=> 1406412000
2014-06-30 13:42	jonalegriaesarte	Target Version	PR14Q3 => PR14Q4
2014-07-21 16:43	jonalegriaesarte	Assigned To	jonalegriaesarte => pramakrishnan
2014-09-01 10:01	rafaroda	Status	new => scheduled
2014-09-01 10:01	rafaroda	Assigned To	pramakrishnan => rafaroda
2014-09-01 10:01	rafaroda	fix_in_branch	=> pi
2014-09-03 17:34	hgbot	Checkin
2014-09-03 17:34	hgbot	Note Added: 0069948
2014-09-03 17:34	hgbot	Status	scheduled => resolved
2014-09-03 17:34	hgbot	Resolution	open => fixed
2014-09-03 17:34	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/26a03c68d7c8e29bfe61454ce6f40f0cc3a6f612 [^]
2014-09-04 14:20	AtulOpenbravo	Review Assigned To	=> AtulOpenbravo
2014-09-04 14:20	AtulOpenbravo	Note Added: 0069965
2014-09-04 14:20	AtulOpenbravo	Status	resolved => closed
2014-09-04 17:31	hudsonbot	Checkin
2014-09-04 17:31	hudsonbot	Note Added: 0069969

Notes
(0068409) egoitz (developer) 2014-06-27 14:16	The problem is reproducible when there are thousends of rows on the fin_finacc_transaction table, and when many of them are posted. That is solved with the following index: CREATE INDEX fin_finacc_transaction_posted ON fin_finacc_transaction USING btree (posted COLLATE pg_catalog."default"); analyze fin_finacc_transaction;

(0069948) hgbot (developer) 2014-09-03 17:34	Repository: erp/devel/pi Changeset: 26a03c68d7c8e29bfe61454ce6f40f0cc3a6f612 Author: Rafa Roda Palacios <rafa.roda <at> ubiquads.com> Date: Wed Sep 03 10:06:34 2014 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/26a03c68d7c8e29bfe61454ce6f40f0cc3a6f612 [^] Fixes issue 26961 Added index to POSTED column of FIN_FINACC_TRANSACTION table --- M src-db/database/model/tables/FIN_FINACC_TRANSACTION.xml ---

(0069965) AtulOpenbravo (developer) 2014-09-04 14:20	Verified.

(0069969) hudsonbot (developer) 2014-09-04 17:31	A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/6b8123291049 [^] Maturity status: Test

Relationships [ Relation Graph ] [ Dependency Graph ]