Task #4900 (closed)
Opened 13 years ago
Closed 13 years ago
DB: Add indexes to (almost) all foreign key columns
| Reported by: | jamoore | Owned by: | jamoore |
|---|---|---|---|
| Priority: | major | Milestone: | OMERO-Beta4.3 |
| Component: | ORM | Version: | n.a. |
| Keywords: | n.a. | Cc: | |
| Resources: | n.a. | Referenced By: | n.a. |
| References: | n.a. | Remaining Time: | 0.0d |
| Sprint: | 2011-04-21 (10) |
Description
In a discussion with Chris, it was decided that the time added to import (and other write-heavy operations) by keeping many more indexes up-to-date would not be significant compared to the Hibernate overhead. Therefore, to speed up write access, indexes will be added to all foreign columns in the OMERO4.3__0 database. (Other columns like "serialNumber" may still need indexes).
This takes the place of:
Change History (1)
comment:1 Changed 13 years ago by jmoore <josh@…>
- Remaining Time changed from 0.5 to 0
- Resolution set to fixed
- Status changed from new to closed
Note: See
TracTickets for help on using
tickets.
You may also have a look at Agilo extensions to the ticket.
(In [dac5dd1ed8750ec8eee248f56e615d89eaa77494/ome.git] on branch develop) Adding almost all FK indexes (Fix #4900)