System hanged after execuate MF that fetched records from another DB

Dears, i had issue when displaying results into grid with data source MF, the MF execute query to external DB and return result more than 50000, when the MF ends the system hanged and i cannot press anything into the application, any suggestions ? Note: i already utilized limit and offset, but as per my understanding we need to utilize limit and offset when we need to manipulate or process something with retrived objects, but my case is to display huge records into grid only.
1 answers

Like you said, you will need to work with limit and offset also when you want to display the data. A datasource microflow has a drawback that all retrieved objects are sent to the client. Your grid is trying to display 50000 records which results in unresponsive client.