Opening a draft and a finalized form with a big csv attachment got slower

[dbemke]

ODK Collect version

the store version 2024.2.4, the master version f38ba7e

Android version

10, 14

Device used

Redmi 9T, Pixel 7a

Problem description

Opening a draft and a finalized form with a big csv attachment got slower. On Adroid 10 (Redmi 9t) opening a draft/finalized of Kobo test form takes ~10 seconds or more (in some cases ~15 seconds + black screen). On Android 14 it also takes a bit more time (but less than Android 10)
On the store version 2024.2.4 opening a draft of the form on Android 10 takes ~5 seconds

Steps to reproduce the problem

1. Create a draft of kobo test form.
   Kobo_Test.xlsx

2. Create a finalized form.

3. Open the draft.

4. Open the finalized form.
   places.csv

XRecorder_10092024_130131.mp4

[lognaturel]

This may need to be filed as a separate issue but I also believe that many queries over Entity Lists will be slower as well. For example:

• expressions with and like city=${city} and age=${age}
• expressions with < or > like age > 18
• expressions with idempotent function calls like starts-with(${fname}, ${start})

We should maintain or improve their performance for the release. @getodk/testers could you please do some checks on this? Let me know if you need help building forms.

[WKobus]

@lognaturel I've checked forms with listed expressions and those are slower, I filed a separate issue for this - #6422