Description
When tapping a Value Relation field configured with "Use completer" enabled, the app freezes for approximately 15 seconds before becoming responsive. The freeze occurs on tap, before any text has been entered into the search field. This issue was not present prior to the 2025.8.0 release and appears to be a regression introduced by the infrastructure migration in that version.
Environment / Application (+ app version, build, operating system)
Mergin Maps version: 2026.1.3
Device: Juniper Cedar CT8X2
OS: Android 10
RAM: 4GB
Lookup table record count: ~6,318 records
Value Relation widget settings: Use completer ✅, Only match from beginning of string ❌
Lookup table format: GeoPackage
Steps to reproduce
- Create a Value Relation widget pointing to a lookup table with ~6,300 records
- Enable "Use completer" in the widget settings
- Open the attribute form on an Android device
- Tap the Value Relation field
- App freezes for approximately 15 seconds before the completer becomes usable
Actual results
The app freezes for approximately 15 seconds on tap. The freeze appears to occur regardless of whether any text has been entered, suggesting the full lookup table is being loaded into memory on tap rather than on keystroke.
Expected results
The completer should open immediately or near-immediately on tap, loading results only as the user types, as it did prior to the 2025.8.0 release.
Workarounds attempted
- VACUUM run on GeoPackage
- Column index added to lookup field
Description
When tapping a Value Relation field configured with "Use completer" enabled, the app freezes for approximately 15 seconds before becoming responsive. The freeze occurs on tap, before any text has been entered into the search field. This issue was not present prior to the 2025.8.0 release and appears to be a regression introduced by the infrastructure migration in that version.
Environment / Application (+ app version, build, operating system)
Mergin Maps version: 2026.1.3
Device: Juniper Cedar CT8X2
OS: Android 10
RAM: 4GB
Lookup table record count: ~6,318 records
Value Relation widget settings: Use completer ✅, Only match from beginning of string ❌
Lookup table format: GeoPackage
Steps to reproduce
Actual results
The app freezes for approximately 15 seconds on tap. The freeze appears to occur regardless of whether any text has been entered, suggesting the full lookup table is being loaded into memory on tap rather than on keystroke.
Expected results
The completer should open immediately or near-immediately on tap, loading results only as the user types, as it did prior to the 2025.8.0 release.
Workarounds attempted