Opened 16 years ago

Closed 16 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.

Change History (1)

comment:1 Changed 16 years ago by Nicklas Nordborg

Resolution: fixed
Status: newclosed

(In [2263]) Fixes #233: Must have an index on the Features table with block, row and column

Note: See TracTickets for help on using tickets.