Get Free Trial

Dataset is too large when expand all

Daniel Cheung asked on November 26, 2021

I met the Error “Dataset is too large. Some fields cannot be expanded. Please narrow down the dataset” when using Expand all function. Is there a way to not show this alert and just let the browser to run even if it takes some time?

3 answers

Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 29, 2021

Hello, Daniel,
Thank you for contacting us.
Please note that the expandAll method is a heavy recursive operation that required the subsequential expanding of each new intersection on the grid. This process and the resulting report not only take time but also resources available to the browser, such as memory. Expanding a large number of intersections is likely to exceed the memory limit defined for a single browser tab. Eventually, it means that the browser may not be able to finish the process even if there is no time limit.
We hope it helps.
Feel free to reach out if other questions arise.

Daniel Cheung December 3, 2021

Hi Illia,
Is it possible to have the result already expanded when the data is first shown in Flexmonster? So that it doesn’t need to do the expand on screen recursively? 

Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 3, 2021

Thank you for your feedback.
You can use expandAll property of the SliceObject to expand all intersections on initialization. However, it still requires a recursive calculation of each new intersection, since they are not stored in the dataset, but created by Flexmonster.
If you want to try to increase the timeout anyway, we suggest using the expandExecutionTimeout property of the OptionsObject. It allows specifying an execution timeout for the expandAllData() function.
Please let us know if it helps.
Kind regards,

Please login or Register to Submit Answer