Some time back I had managed to install the complete protein database of
the HGP into PostgreSQL-7.0.2. This comprised of 65 tables with typical
sizes of 80'000 records for about 10 tables and one table of 650'000
records. I never did any benchmarks but it was very fast. C interface
worked at about 2000 queries/sec and perl interface at 40
queries/sec. Guess that's fast, I've never run Oracle so can't
compare. And PostgreSQL's Object Relational design and already existing
set of varied datatypes allows for strange data from the Human Genome
Progect rather easily.
Anyone using PostgreSQL for Bioinformatics on this list?
\Indraneel
On Tue, 6 Mar 2001, Rajesh Fowkar wrote:
> Guru had posted this on ilug-goa.
>
> >We would be keen to hear your experiences here, especially on production
> >level databases.
--
http://www.indialine.org
----------------------------------------------
An alpha version of a web based tool to manage
your subscription with this mailing list is at
http://lists.linux-india.org/cgi-bin/mj_wwwusr
