user merge very slow to process on large datasets
Bug #1374551 reported by
Chris Sharp
This bug affects 4 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
High
|
Unassigned | ||
2.5 |
Fix Released
|
Undecided
|
Unassigned | ||
2.6 |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
We have seen long (20 to 30 second) delays when performing patron merges either via the staff client or directly via the actor.usr_merge() function. Debugging reveals a need for an index on money.billing(
Evergreen 2.5.1
OpenSRF 2.2
PostgreSQL 9.3
Ubuntu 14.04 LTS
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
My solution:
http:// git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/user/ csharp/ lp1374551_ fix_merge_ slowness
user/csharp/ lp1374551_ fix_merge_ slowness