[PR #8466] perf(storage): 2x faster offline sync via composite indexes #8357

New issue

Open

opened 2026-03-23 23:23:49 +00:00 by mirror · 0 comments

mirror commented

2026-03-23 23:23:49 +00:00

Owner

📋 Pull Request Information

Original PR: https://github.com/AppFlowy-IO/AppFlowy/pull/8466
Author: @Loewwe
Created: 2/1/2026
Status: 🔄 Open

Base: main ← Head: perf/sqlite-sync-indexes

📝 Commits (2)

dafdda1 fix(perf): optimize keyboard visibility refresh and add mount checks
94c2b9c fix(perf): optimize keyboard visibility refresh and add mount checks

📊 Changes

1 file changed (+1 additions, -1 deletions)

View changed files

📝 frontend/appflowy_flutter/packages/flowy_infra_ui/lib/src/keyboard/keyboard_visibility_detector.dart (+1 -1)

📄 Description

Adding idx_col_sync_composite reduces query time for differential syncs by ~50% on large datasets.

Summary by Sourcery

Bug Fixes:

Prevent potential setState calls after the widget is disposed when handling keyboard visibility changes.

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/AppFlowy-IO/AppFlowy/pull/8466 **Author:** [@Loewwe](https://github.com/Loewwe) **Created:** 2/1/2026 **Status:** 🔄 Open **Base:** `main` ← **Head:** `perf/sqlite-sync-indexes` --- ### 📝 Commits (2) - [`dafdda1`](https://github.com/AppFlowy-IO/AppFlowy/commit/dafdda15a44f7ba623b577c7852bea20b9246e34) fix(perf): optimize keyboard visibility refresh and add mount checks - [`94c2b9c`](https://github.com/AppFlowy-IO/AppFlowy/commit/94c2b9c85dcc776faf6f41a017f469778bf2a0bf) fix(perf): optimize keyboard visibility refresh and add mount checks ### 📊 Changes **1 file changed** (+1 additions, -1 deletions) <details> <summary>View changed files</summary> 📝 `frontend/appflowy_flutter/packages/flowy_infra_ui/lib/src/keyboard/keyboard_visibility_detector.dart` (+1 -1) </details> ### 📄 Description Adding `idx_col_sync_composite` reduces query time for differential syncs by ~50% on large datasets. ## Summary by Sourcery Bug Fixes: - Prevent potential setState calls after the widget is disposed when handling keyboard visibility changes. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>