[ensembl-dev] query limit in variation API...

[Will McLaren]

Hi Juha,

You may find the following useful:

http://www.ensembl.org/info/docs/Doxygen/core-api/classBio_1_1EnsEMBL_1_1Registry.html#ac77cb4f710542fe0d53f1c8f09db5c4d

If you run this method at the start of your script, the Registry should
maintain its connection to the database server more reliably. Using this
comes with some overhead (the DB gets pinged before every query), which is
why it is not enabled by default.

Regards

Will


On 30 November 2012 10:36, <juha.muilu at kolumbus.fi> wrote:

> Thanks Will
> Actually the failure don't always happen exactly after that many calls,
> perhaps +/-5. It is a simple loop which used to work with the rev 68. Good
> to know that there are no hidden cpu etc. limits in api code/mysql.  I will
> investigate more.
> Cheers, Juha
> Will McLaren [wm2 at ebi.ac.uk] kirjoitti:
>
>> Hi Juha,
>>
>> There is no limits if you are using the Perl API, no.
>>
>> If your script repeatedly fails after 877 calls, I suspect there is
>> something in the 878th which is causing it to fail - if you could let us
>> know the details of that we may be able to debug.
>>
>> Regards
>>
>> Will McLaren
>> Ensembl Variation
>>
>>
>> On 24 November 2012 19:25, <juha.muilu at kolumbus.fi> wrote:
>>
>> > Hi
>> > Wondering if queries are limited in the latest variantion api or
>> > something? My script, which used to work with the version 68, now dies
>> > after 877 calls to $variation_adaptor->fetch_by_****name... Best, Juha
>> >
>> >
>> > ______________________________****_________________
>>
>> > Dev mailing list    Dev at ensembl.org
>> > Posting guidelines and subscribe/unsubscribe info:
>> > http://lists.ensembl.org/****mailman/listinfo/dev<http://lists.ensembl.org/**mailman/listinfo/dev>
>> <http://**lists.ensembl.org/mailman/**listinfo/dev<http://lists.ensembl.org/mailman/listinfo/dev>
>> >
>>
>> > Ensembl Blog: http://www.ensembl.info/
>> >
>>
>> ______________________________**_________________
>> Dev mailing list    Dev at ensembl.org
>> Posting guidelines and subscribe/unsubscribe info:
>> http://lists.ensembl.org/**mailman/listinfo/dev<http://lists.ensembl.org/mailman/listinfo/dev>
>> Ensembl Blog: http://www.ensembl.info/
>>
>>
>
>
> ______________________________**_________________
> Dev mailing list    Dev at ensembl.org
> Posting guidelines and subscribe/unsubscribe info:
> http://lists.ensembl.org/**mailman/listinfo/dev<http://lists.ensembl.org/mailman/listinfo/dev>
> Ensembl Blog: http://www.ensembl.info/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20121205/bfa6f2b2/attachment.html>