Having problem with Query builder when we have more records

Avatar

Avatar

umamaheswariy46

Avatar

umamaheswariy46

umamaheswariy46

17-09-2019

Having problems with the querybuilder.

We have our own dashboards for the clients. The data comes into these dashboards based on properties defined in the nodes.

To display these dashboards we are using querybuilder api to get the data but recently seeing so many issues like reached 10000 stopping the process etc.

Is there any way that we can optimize the queries or best way to retrieve the data without this msg. That would be great.

Thanks in Advance.

View Entire Topic

Avatar

Avatar

Ravi_Pampana

MVP

Avatar

Ravi_Pampana

MVP

Ravi_Pampana
MVP

17-09-2019

Hi,

You can update the below configuration

Screen Shot 2019-09-17 at 7.20.08 PM.png

In memory read limit property can be increase to your needs.

But note this is impact the performance of the server and you should be adding proper indexing for the properties, so that performance wont be effected.

Hope this helps !