[Biojava-l] Different implementation of Sequence?

[Y D Sun]

> -----Original Message-----
> From: Thomas Down [mailto:thomas at derkholm.net] 
> Sent: 05 June 2003 10:17
> To: Y D Sun
> Cc: biojava-l at biojava.org
> Subject: Re: [Biojava-l] Different implementation of Sequence?
> 
> Okay, the postgres version of that schema is missing many 
> "create index" commands (it was autogenerated from the MySQL 
> schema.  MySQL implicitly creates an index for the primary 
> key of a table, while PostgreSQL does not).
> 
> The most important one is:
> 
>     CREATE INDEX sf_pk ON seqfeature (seqfeature_id);
> 
> That should get the system running substantially faster.
> 

Can I run the command in an existing db? Now I am running it in a db
containing 10 sequences, but it is hanging there. 

George

> Also try:
> 
>      CREATE INDEX ot_pk ON ontology_term (ontology_term_id);
>      CREATE INDEX sfs_pk ON seqfeature_source (seqfeature_source_id);
> 
> I'll try and get a better schema file up today.
> 
>     Thomas.
>