Hello,
We have noticed that Experiment overview is very slow for large
experiments (>40 raw bioassays) with many items annotated (mainly
samples). I takes over a minute for some of the experiments to load
overview (or re-validate). I narrowed the issue down to this line:
List inherited = annot
Pawel Sztromwasser wrote:
> Hello,
>
> We have noticed that Experiment overview is very slow for large
> experiments (>40 raw bioassays) with many items annotated (mainly
> samples). I takes over a minute for some of the experiments to load
> overview (or re-validate). I narrowed the issue down
Hi Nicklas,
I agree that the query is rather complex and has to take some time to
execute, but over 200ms? Besides, the effect that it is causing
(extremely long experiment overview loading) is really annoying.
I had a look at db server logs and found the query:
select distinct annotation0_."i
Hi all,
The 2.11 release will target performance issues. The next release is
2.10 but we have not set a dead line for the 2.10 release yet. However,
a hopefully performance boosted BASE 2.11 should be out during the
spring, until then we have to live with some slow BASE clicks. I agree
with Pa
> Hi Nicklas,
>
> I agree that the query is rather complex and has to take some time to
> execute, but over 200ms? Besides, the effect that it is causing
> (extremely long experiment overview loading) is really annoying.
> I had a look at db server logs and found the query:
>
>
> select distinct
Jari Häkkinen writes:
> Hi all,
>
> The 2.11 release will target performance issues. The next release is
> 2.10 but we have not set a dead line for the 2.10 release yet. However,
> a hopefully performance boosted BASE 2.11 should be out during the
> spring, until then we have to live wit
Nicklas Nordborg wrote:
>
>> Hi Nicklas,
>>
>> I agree that the query is rather complex and has to take some time to
>> execute, but over 200ms? Besides, the effect that it is causing
>> (extremely long experiment overview loading) is really annoying.
>> I had a look at db server logs and found th
Thanks for this! It seems to a very thorough analysis of the problem.
Can you create a ticket for this and at least link to this thread in the
mailing list archive?
/Nicklas
Pawel Sztromwasser wrote:
> Nicklas Nordborg wrote:
>>> Hi Nicklas,
>>>
>>> I agree that the query is rather complex and h
Done
Nicklas Nordborg wrote:
> Thanks for this! It seems to a very thorough analysis of the problem.
> Can you create a ticket for this and at least link to this thread in the
> mailing list archive?
>
> /Nicklas
>
>
> Pawel Sztromwasser wrote:
>> Nicklas Nordborg wrote:
Hi Nicklas,
>
Forgot the link http://base.thep.lu.se/ticket/1232
Nicklas Nordborg wrote:
> Thanks for this! It seems to a very thorough analysis of the problem.
> Can you create a ticket for this and at least link to this thread in the
> mailing list archive?
>
> /Nicklas
>
>
> Pawel Sztromwasser wrote:
>> N
Pawel Sztromwasser wrote:
> Forgot the link http://base.thep.lu.se/ticket/1232
Thanks a lot.
/Nicklas
--
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/s
11 matches
Mail list logo