getQueryDetails() slow when query contains multiple lookups?

LabKey Support Forum (Inactive)
getQueryDetails() slow when query contains multiple lookups? daves  2010-03-11 10:31
Status: Closed
 
Hi Ben,

The schema browser calls getQueryDetails when you view a particular query, so do you notice that the schema browser also take longer to display the details of the study.Participant as well? I wouldn't expect it to be all that much longer if you have 10 extra lookup columns, but perhaps there is something we can do to improve performance (caching and such).

If you just need some basic meta-data about a few columns, you can use selectRows specifying a maxRows=0. This will return the full metaData and columnModel sections, but the rows section will be an empty array. The selectRows API allows you to specify a list of columns you want, so you can select just the few columns you need.