[Biojava-l] Different implementation of Sequence?

[Y D Sun]

> -----Original Message-----
> From: Simon Foote [mailto:simon.foote at nrc-cnrc.gc.ca] 
> Sent: 05 June 2003 12:59
> To: Y D Sun
> Cc: biojava-l at biojava.org
> Subject: Re: [Biojava-l] Different implementation of Sequence?
> 
> 
> Just to add my 2 cents worth.
> 
> I'm using the latest version of the BioSQL schema within 
> MySQL and the 
> filters are quite fast.  On a database containing 18 complete 
> bacterial 
> genomes, fetching a given gene by name which uses a combination of 5 
> filters in my case, takes approx. 1-2 seconds.
> 

Simon,

Have you tried to filter all CDS sections of a complete bacterial
genome? In my experience with PostgreSQL, it takes only a few seconds to
filter a simple feature. However, it needs more than one minute to
filter thousands of CDS's in a genome. 

George