Million records in the database

we have millions of data into our database with a complex relationship between the entity. I need to show the data on the page but it is taking a lot of time to load the page. What will be the optimum solution for this kind of scenario? 
2 answers

Hi chandan,


   For your case , Use Task Queue . It will run in the background and updates the data.

Check on this ‘’ 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.