Speed of Queries in Labkey

LabKey Support Forum
Speed of Queries in Labkey marcia hon  2018-03-08 08:05
Status: Closed
 
Hello,

Is there some configuration settings that I can modify in order to make my Labkey queries run faster?

I'm having a very hard time with queries that do many calculations and also pivots.

One query took up to 30 minutes to return results.

Thanks,
Marcia
 
 
Jon (LabKey DevOps) responded:  2018-03-09 16:10
Hi Marcia,

Have you taken the time to review our robust Support Documentation?

https://www.labkey.org/Documentation/wiki-page.view?name=default

Many of your questions can be answered in our docs and we even have videos to help you understand how to both use LabKey and understand the functionality:

https://www.labkey.org/Documentation/wiki-page.view?name=videos

For future, please do your best to consult our fantastic docs first before posting to the Community Forums.


Regarding the speed of your queries, this is difficult to say. You should do your best to make sure your queries are optimized as much as possible.

It could also possibly be inadequate hardware that your LabKey instance is sitting on and there are not enough resources to run the queries:

https://www.labkey.org/Documentation/wiki-page.view?name=beforeInstall

The number of rows also matters as well since going back to optimization, the more data you have, the longer it may take to respectively render. If you are running calculations and doing pivots within those queries, that can also take a little longer than your standard SELECT statement.

Regards,

Jon