> -----Original Message----- > From: Simon Foote [mailto:[EMAIL PROTECTED] > Sent: 05 June 2003 12:59 > To: Y D Sun > Cc: [EMAIL PROTECTED] > 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 _______________________________________________ Biojava-l mailing list - [EMAIL PROTECTED] http://biojava.org/mailman/listinfo/biojava-l
