[Bioperl-l] Optimizing Bioperl db queries

[Law, Annie]

Hi,

I would appreciate help on the following.  I am trying to create an
annotation database and
Am trying to obtain from starting point clone ids and end point being
Locuslink id's and GO terms, gene symbols, gene names.

I have loaded my bioperl-db database with scripts such as load_ontology.pl
and loadseqdatabase.pl.
I am using VB and sql queries to pull out the data.  

I am able to get the data that I want however it is quite slow.  I have 15
clone ids and it takes about 30s to retrieve
The data that I would like to get.  
This is only my test case and there may be times that my input will be 15000
entries.
Aside from the bioperl tables I have some other tables that are used.  So in
total I have about 9 sql queries
And some of these queries are in loops.

How are the people out there optimizing the set of queries to get a faster
retrieval?
I have indexed some tables but I think there is a better solution.

Thanks very much,
Annie.