Daniel Franke <[EMAIL PROTECTED]> wrote: > > CREATE TABLE genotypes (markerid integer NOT NULL REFERENCES marker(id), > individualid integer NOT NULL REFERENCES individuals(id), > genA integer, > genB integer) > > CREATE UNIQUE INDEX genotypeidx ON genotypes(markerid, individualid) > > ---------------------------------------------------------- > Get all markers of a single individual > $> time snpdb-query db "SELECT * from genotypes WHERE individualid==1" > dump > > real 9m10.964s > user 2m22.085s > sys 0m27.458s >
This query will likely go a lot faster if you create an index on genotypes(individualid): CREATE INDEX genotypeidx2 ON genotypes(individualid); Of course, your partition is already full, so I don't guess that is really a possibility, huh? -- D. Richard Hipp <[EMAIL PROTECTED]>
