InboxFlow

Performance degraded noticeably on inboxes with 1 000+ emails. Fixed by extracting memoized row components (React.memo + useCallback), enabling FlatList windowing, and adding a module-level avatar cache to prevent re-fetching on scroll remount. The bundles unread badge was always showing 50 — equal to the page limit — because the count was derived from paginated results. Replaced with a dedicated COUNT DISTINCT SQL endpoint that returns the real number regardless of pagination. "Mark all as read" caused a network timeout on large inboxes. The root cause was a synchronous Gmail API call that fetched thousands of records before responding. Fixed by moving the Gmail sync to a fire-and-forget setImmediate block so the HTTP response returns immediately after the database update. Automation rule conditions were stored as DataTypes.JSON in Sequelize, but certain database configurations returned them as raw strings. This silently broke the unfreeze feature. Fixed with a defensive parseArr() helper that handles both parsed arrays and JSON strings.