The story of how an 'Excel-as-DB' Power App collapsed at the 500th record, and the design standards for surviving in the field

Excuse me, the app we built in-house with Power Apps has suddenly become very slow, and we can't search for data anymore.