Backend database issues

When viewing the backend database often:

  1. Data fails to load on occasion. Requires page refresh.
  2. Data takes ages to load
  3. Data in table is not the current data unless you refresh the table (go to another table and back again)
  4. Bulk operation doesn’t load the data list at all sometimes
  5. Values show as empty when they are not (for deleted data)
  6. Empty items show in lists (when item has been hard deleted)
  7. Old option sets that have been deleted still show in the data instead of being nulled on delete (even after data cleanup is run)

I just wasted 10 minutes debugging a workflow because the database wasn’t loading current data despite changing the table to force it to reload (which normally works but this time didn’t).

Posting here so others are aware of the issues and don’t waste their own time.