How to handle loading of thousands of rows in UI table in Oracle VB

Hello Members,

I am using my business object to load data in table.

Table data property is bind to SDP.

Now I want my table to handle huge data also.

I have below doubts:

1: What things I can do so that my table can hold thousands of rows of data without impacting performance?

2: what and all approaches I can follow to achieve this use case?

3: From get rest call, what should be the optimize way to get all rows?

4: Should I use BO or ORDS to fetch and populate row in UI table?

Kindly suggest.

Thanks

Rohit