Hello Manasa,
If your app stores more data eventually then you can integrate elastic search.
Retrieve the data from the elastic search query and render it in the user interface.
It requires customization to achieve it.
Thanks
It would be so nice if Mendix started to support the table partioning possibilities of Postgres. But till then you have to create it yourself by duplicating the entities and moving the object from the source entity to the archive entity. But searching will be complicated because you should look in two different tables.
Regards,
Ronald
[EDIT]
I created a request for this in the idear forum: https://community.mendix.com/link/ideas/2382 So vote if you think this is a good idear.
@ sandeep bhole – were you able to achieve this? How did you do it?