Hi Alex,

In some cases, queries can be optimized through refactoring the SQL code to be more efficient. In others, you would have to adjust the schema itself. This can mean changing the tables themselves (e.g. Having some of the data in lists or other data types instead of assays; although it's difficult to say without knowing the type of data we're dealing with). Otherwise, it means adding indices instead.

At the moment, we don't have a good way for adding custom indices for these kinds of administrator-defined data types like assays and datasets. It's possible to do it directly on the database itself, but we don't really support this either can can't guarantee an increase in performance consistently, but it will definitely do a little better than your standard labkey configuration that we can predict.

Regards,

Jon