Opened 18 years ago
Closed 18 years ago
#233 closed defect (fixed)
Must have an index on the Features table with block, row and column
| Reported by: | Nicklas Nordborg | Owned by: | Nicklas Nordborg |
|---|---|---|---|
| Priority: | major | Milestone: | BASE 2.0 RC2 |
| Component: | core | Version: | |
| Keywords: | Cc: |
Description
Raw data import when an array design is connected is *very* slow (approx 50 spots/second with only one array design in the database). Adding an index speed things up a lot. By the way, the index should be unique since no block should have multiple entries with the same row and column coordinates.
We may also need an index on raw data tables on the same columns.
Note:
See TracTickets
for help on using tickets.
(In [2263]) Fixes #233: Must have an index on the Features table with block, row and column