• Sign In
  1. Messages

Capacity of "Lists"?

LabKey Support Forum

View Message

view list print
Capacity of "Lists"? stravsmi  2023-06-22 23:27
Status: Active
 

Hi,

we are developing a solution based on LabKey Community and have different options for how to implement some functionality.

Is there a practical limitation to how large a "List", with per-row indexing, can get?
Is it feasible to have a "List" with many millions of rows, and to query it in reports?
 
 
mohara responded:  2023-06-23 14:24

Hi, and thanks for reaching out.

You may run up against database limits (on number of columns or overall capacity) but there isn't an intrinsic limit on list size in LabKey. We have users successfully using lists with millions of rows. Depending on the reporting and querying you plan to do, of course you may run into performance issues, but that would be true of any large set of data. Lists are a flexible option for representing data that may meet your needs.

Hope that helps,

--Molly
 
stravsmi responded:  2023-06-27 02:12
Status: Closed

Thanks!