Record is failing for 5000 rows giving "An Error occurred while retrieving data"

Hi All,

We have a record mapped to a view which fails frequently giving "An Error Occurred While Retrieving The Data". When we executing Select * from <View> in database we are getting data within .33 seconds, but in Records after waiting for 10-15 seconds it fails.

We are on cloud and our database is on premise oracle database.

I am looking for alternatives to handle this situation like:

1. Can we restrict the data being fetched in record list (E.g. only 10 rows)

2. Search / Filters should work on complete data.

Any suggestions would be appreciated

Thanks