Posted by pdrake on November 22, 2011 at 7:24pm
1 follower
| Project: | Persistent URL |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
Add an index on provider, id columns for improved performance.
Comments
#1
Add index on provider, id columns for improved performance. For a PURL table with ~15,000 entries, this decreases query time from 13ms to 0.5ms for queries like the following (which occur in purl_load). A busy site may execute millions of such queries each day.
SELECT * FROM {purl} WHERE provider = ? AND id = ?