UI Builder: Data Resource Records Lookup increase limit above 1000

[Bernard Esterhu]

In UI Builder, I'm creating a Data Resource (Global -> Look Up Records). There is a "Max results" field that is set to 1000 by default. The tooltip info states: 

Maximum results returned. NOTE: The property has a default upper-cap of 1000. To modify the upper-cap, create/update the system-level property `glide.graphql.gliderecord.maxResults.limit` and set the desired upper-cap.

I would like to increase this limit, however I do not find the glide.graphql.gliderecord.maxResults.limit property in the sys_properties table. 

Is there a place I can configure this limit?

[Vijayalakshmi P · Accepted solution]

Please create that property and set the limit as per your requirement.

[Bernard Esterhu]

@Vijayalakshmi P thanks for the hint.

I have increased this parameter to 40000. This works, however saving the page is extremely slow, and loading the actual page to preview is also very, very slow. 

Running this same query in Background - Script completes in less than a second (returns around 36000 results), so I don't understand why this is causing the UI Builder to run so slow..?

[Vijayalakshmi P]

@Bernard Esterhu - How do you use your Data Resource that has Lookup records? 

[Bernard Esterhu]

Hi @Vijayalakshmi P 

I'm using the data resource to populate a dropdown list. But even if I do not use the data resource, I only create it, saving the UI Builder page and loading the preview page is extremely slow.