[ensembl-dev] mySQL local ENSEMBL instalation

[Duarte Molha]

Dear Developers

In my group we have done local installations of the ensembl database in order to improve performance and also because we do not what to tax your servers with queries.

However in the latest releases we have been having difficulties installing the tables in our internal database... especially the alleles table.
The latest 66 release we installed took 8 days to process the alleles table and I am sure that it should not take this long!

We have followed the instructions found here: http://www.ensembl.org/info/docs/webcode/install/ensembl-data.html

On this page: http://www.ensembl.org/info/docs/variation/database.html#db_load

You indicated that the alleles table (for version 61) should take about 3 hours to process. Since the Alleles table for version 67 is more than double in size we would expect for it to take between 6 to 9 hours but never 8 days!

Can you tell me if we are missing something or give us some workaround in order to accelerate the process?

Best regards

Duarte Molha

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20120514/fac57cf3/attachment.html>