[STOR-777] Inefficient query used to update SURL status when a releaseFiles is called Created: 09/Mar/15 Updated: 22/Jan/16 Resolved: 13/Mar/15 |
|
| Status: | Closed |
| Project: | StoRM |
| Component/s: | None |
| Affects Version/s: | 1.11.7 |
| Fix Version/s: | 1.11.8 |
| Security Level: | Public (Visbile by non-authn users.) |
| Type: | Bug | Priority: | Major |
| Reporter: | Andrea Ceccanti | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
The query used to update the status of a list of SURLs after a releaseFiles operation does not leverage the index built on the SURL hash value, resulting in unnecessary high load on the MySQL server which slows down request handling. |