Skip to main content
kavyan471063
kavyan471063
Known Participant
March 1, 2023
Question

Memory Threshold error when querying data even after passing batchSize as 20

  • March 1, 2023
  • 13 replies
  • 0 views

Hi All,

I have a requirement where I need to query with 40k input and output will be 2x or 3x of that. I have passed the batchSize as 20 and fetchTotalCount as true. I need to display the data in grid and need to export all in a excel also. But I am getting a time out error. Is there any way I can query these number of data in UI. Please help us with your suggestions.

Regards,

Kavya

    13 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    March 1, 2023

    Limiting the batchSize to 20 should prevent the memory issue. A timeout could still occur. Do you query data from a database view?

    Can you explain your situation in more detail? That might help us to better understand and advice.

    kavyan471063
    kavyan471063Author
    Known Participant
    March 1, 2023

    I previously used Stored procedure to query data from DB view, But we have limitation in returning data. So we use query Entity and passed 4k input and got result upto 7k. Now user wants to give 40k input and expect the result in grid. We are querying it from Oracle DB view. and pass this data to Grid and the export to excel function. Let me know if you require additional information in analysis.

    Thanks 

    Kavya

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    March 1, 2023

    I am still not sure I understand what you are doing. Anyways, you have to make sure to keep the queried data below 1MB and the query time below the timeout. If that does not meet your requirements, you will have to find a different way.

    Terms & ConditionsAccessibility statement