Just stumbled into this – we have over 31M records in this thing AND we do NOT have ANY workflows defined!!
It took mysql 21 minutes to return that result from:
MariaDB [suitecrm]> select count(*) from aow_processed;
+----------+
| count(*) |
+----------+
| 31340634 |
+----------+
**1 row in set (21 min 11.17 sec)**
What gives?
Following this advice now: