Hello,
I found something interesting regarding BASE2 performance on Postgres
(we have 8.3 but I suppose it is valid for previous versions as well).
Recently I was unable to delete ArrayDesign (Illumina Human 8Ref, no
items connected to it, features imported), because database query was
Oh, I didn't know this. We are mainly working with MySQL which
implicitly creates an index for every foreign key. I agree that indexes
are certainly needed on the big tables.
I guess we could make the 'updateindexes.sh' script check that each
foreign key definition has an associated index.
