Question

Iterate through a Large Table?

0

How can I iterate through a large table with thousands of objects? I want to create a consistency check routine that scans through a table for objects/records that have no link to other objects. Putting them in a list is not the right way in my view. Should I use xpath constraint to check for missing association and put that in a list? Any better suggestion?

asked 2020-09-21

Rob de Leeuw

2 answers

Michiel Arts · Accepted Answer · 2020-09-21

You can use batching, see https://medium.com/mendix/five-tips-for-working-with-large-database-tables-in-mendix-170210f6f6fd

or

https://www.mendix.com/blog/limits-and-offsets/

Tim v Steenbergen · Accepted Answer · 2020-09-21

“Should I use xpath constraint to check for missing association and put that in a list?” Yes.

An alternative is to retrieve your objects using OQL, although in this situation the performance-difference will not be substantial.