For your case , Use Task Queue . It will run in the background and updates the data.
Check on this ‘https://docs.mendix.com/refguide/task-queue/’ you will get the idea
If you are searching and sorting the data, have you set indexes on the appropriate attributes? This can dramatically improve performance if done correctly. There is more information in the Mendix documentation on this.
Good luck and I hope this helps.