Loading High Amount of Data in RDM Takes Too long

Reported for version 10


RDM is taking an unreasonable amount of time to load data.


If loading a large amount of data takes too long, it can be the sign of data invalidity. The RDM application offers a vast amount of validation features, and as a result it could be that the majority of the data loaded into the application is INVALID. In this case, every INVALID record will be separately inserted into a special table in the RDM repository, resulting in a performance issue. If you are going to load a big amount of data it is recommended  that a importing a sample of the data first to check if these are VALID