Hi All,
I am trying to retrieve data from DB by using query entity. I am able to fetch 10,000 records beyond that I am getting "a!queryEntity: An error occurred while retrieving the data".
I have more than 18000 records in my table which I need to display in a paging grid with filter options. I have check the performance of my view at DB end. It is not even taking 1 second to execute that view not sure why with query entity is not able to fetch all records. When in my paging info I am giving batchsize more that 10000 or -1, it gives me the error below this, it is working fine. Not sure if query Entity has limitation in fetching number of rows.
Please share, if I can use some other way to fetch all the records from DB and use in my interface.
Thanks in advance !!
Regards
Anusha
Discussion posts and replies are publicly visible