Question

Batching and changing

0

Hi all, What’s the current best practise for retrieving and changinglots of records? I have about 85000 existing records that need to each be given a new enumeration. Many thanks, Garion

asked 2019-05-20

Garion Swann

4 answers

Aswin van Braam · Answer 1 · 2019-05-20

There is a lecture available:

https://gettingstarted.mendixcloud.com/link/module/21/lecture/85

Robin Vervuren · Answer 2 · 2019-05-20

I saw a Mendix webinar once where they recommended to build a MF that updates the records in batches of 500.

Can't seem to find the link to that webinar though...

Chris Park · Answer 3 · 2022-09-05

Updated link to batching lecture: https://academy.mendixcloud.com/link/modules/21/lectures/85/3.3-Using-Batches

Tim v Steenbergen · Answer 4 · 2019-05-20

If you have the authorisation: Run an UPDATE-query in the database. By far the fastest way.

But this is a Mendix forum, so you will want to build it using Mendix, go with lecture/85 like Aswin says.