Recently, I was involved in investigating a performance issue. The initial thought for the issue was within the standard SysQuery::countLoops() method, but after some more deep dive, the culprit was due to some calculation of virtual fields. In this post, I will elaborate on the purpose and behavior of the SysQuery::countLoops() method and how the performance was impacted by virtual fields.

Read more