0028937: Long time to show data on the return remittance window

Description

Having a big amount of data on the remitances tables,
when searching the data for a remmitance with arround 300 lines it takes 6 seconds to show the data

Steps To Reproduce

-ON an environment with big amount of data on the remmitances tables
fin on the popup a remmitance with arround 300 lines.
-When clicking on search button it takes 6 seconds.

Proposed Solution

With the following index the time has been reduced from 6 seconds to 1,3:

CREATE INDEX rem_remitline_payment
  ON rem_remittanceline
  USING btree
  (fin_payment_id COLLATE pg_catalog."default");

Tags

Performance

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0026941

closed

fsoto82

Improve performance on the settle remitance process

Notes
(0074904) umartirena (reporter) 2015-02-25 11:01	Issue duplicate of 26941

Issue History
Date Modified	Username	Field	Change
2015-02-13 12:22	egoitz	New Issue
2015-02-13 12:22	egoitz	Assigned To	=> eduardo_Argal
2015-02-13 12:22	egoitz	Resolution time	=> 1425078000
2015-02-13 12:35	egoitz	Tag Attached: Performance
2015-02-24 10:21	egoitz	Assigned To	eduardo_Argal => umartirena
2015-02-25 11:01	umartirena	Review Assigned To	=> umartirena
2015-02-25 11:01	umartirena	Relationship added	duplicate of 0026941
2015-02-25 11:01	umartirena	Note Added: 0074904
2015-02-25 11:01	umartirena	Status	new => closed
2015-02-25 11:01	umartirena	Resolution	open => duplicate