The performance of my lookup table query rules is currently all over the place with widely different results between tests made at the same time, on the same data, in a row.

The same rule can vary from 100ms up to 1 full minute. Rules that delete have the largest gaps.

If I run these rules over and over, I get completely different results from 100ms to 1 minute.

The amount of rows I am deleting is the same, 0. I am just running the rule to see if anything needs to be deleted so it is returning 0 rows effected. The amount of data in the table is the same as well. So I can not understand why I am getting such wild gaps in my rule performance.

A workflow can take anywhere from 2 seconds to 5 minutes to finish updating tables.

I am dealing with a very small amount of data and I would like to make sure my rules are all performing at under 1 second at the least. How can I keep the rules performing with consistency?