[BioSQL-l] How fast to execute load_seqdatabase.pl parsing swiss-prot data into Oracle database?

Arthur Fen arthur.fen at vitagenomics.com
Thu Oct 9 04:00:52 EDT 2003


Dear sir:
 
I tried to load decompressed SWISSPROT data (Release 41.13 of
21-Jun-2003,"sprot.dat") into ORACLE database Server (ver 9.2.0.1.0 on
Linux 9.0) by using the load_seqdatabase.pl script.
 
If I use following status to run the program, could you estimate the
reasonable speed and time spanning for loading data?
Environments:
2 AMD 2000+ CPU, 4 GB RAM, 80 GB HDD, Virtual swap 6G space.
RedHat Linux 8.0,
Perl v.5.8.1 (Compile on default setting by myself),
BioPerl v.1.22, DBI v.1.37, DBD::Oracle v.1.14 and newest bioperl-db 

 
I got a relatively slow motion about 5,000 records/hr in comparing to
mySQL.  Is it normal for using Oracle? Or I need to do some tuning for
my system?
 
Thanks for your answer...
 
 
                          Arthur


More information about the BioSQL-l mailing list