Table partitioning and Clustered Indexs in DB with Mendix Public Cloud
0
The Mendix applications are getting older and older which is good. But is also means that table sizes can become huge. I was checking but not able to find the option to implement the partitioning and Clustered Index. Now you have to create your own archive tables and must wrestle with the problem of searching over different tables. Can anyone suggest if we can implement the partitioning on my table? Thanks, Sumit
asked
Sumit Pachouri
1 answers
0
The most simple way is to have an archive boolean in the entity so you can use that boolean in grids to quickly filter out the old data and only show recent data. That way you do not have to create archive tables. But you do need to make a scheduled event that determines which records get the archive boolean set.