Will there be a performance impact if a validation XML is used without max rows? Let’s say the hierarchy select in the validation XML generates thousands of records. Will it be beneficial to limit it to just one (or the first) row?
In SQL, it’s typical to use a top X statement to minimize any performance impact.
Best answer by Saranga Amaraweera
View original
+22
Hi
Since your main intension is only to validate the xml business rule when the conditions in the validation xml are met ( is either returning true or false), it is always recommended to optimize your xml message if it returns more than one result. There is no point of returning multiple rows in the result as the validation xml behaves similar to a boolean expression (true or false). Hence, as per your question, of course it's beneficial to limit the result from the performance perspectives. (However the maximum row limit has been set to 1000 rows by default in the app params).
Thanks Saranga.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
