Search Issue Tracker

By Design

Votes

0

Found in

2019.2

2019.2.8f1

2019.3

2020.1

Issue ID

1205936

Regression

No

Connecting to SQLite plugin takes from 2 to 3 times longer with some devices compared to editor

Mobile

-

Steps to reproduce:
1. Open the attached project "Case_1205936"
2. Build it on android device
3. Press "Button"
4. Notice the load time on the screen

Expected results: Load time is somewhere from 100 to 150 ms
Actual results: Load time is around 250 or 600 ms depending on the device

Reproducible with: 2019.2.17f1, 2019.3.0f3, 2020.1.0a17

around 200 ms
VLNQA00099, Google Pixel XL (Pixel XL), Android 9, CPU: Snapdragon 821 MSM8996 Pro, GPU: Adreno (TM) 530

around 100 ms
VLNQA00287, Motorola moto g(7) power (moto g(7) power), Android 9, CPU: Snapdragon 625 MSM8953, GPU: Adreno (TM) 506

around 100 ms
VLNQA00229, Oneplus OnePlus6T (ONEPLUS A6013), Android 9, CPU: Snapdragon 845 SDM845, GPU: Adreno (TM) 630

around 100.00 ms
VLNQA00170, Google Pixel 2 (Pixel 2), Android 10, CPU: Snapdragon 835 MSM8998, GPU: Adreno (TM) 540

650 ms
VLNQA00098, Lge LG G4 (LG-H815), Android 6.0, CPU: Snapdragon 808 MSM8992, GPU: Adreno (TM) 418

around 125 ms
VLNQA00015, Samsung Galaxy Note8 (SM-N950W), Android 8.0.0, CPU: Snapdragon 835 MSM8998, GPU: Adreno (TM) 540

around 200 +
N/A, Xiaomi POCO F1 (POCOPHONE F1), Android 9, CPU: Snapdragon 845 SDM845, GPU: Adreno (TM) 630

first load: 963 ms
usually around 600 ms
VLNQA00070, Lenovo Lenovo PHAB2 Pro (Lenovo PB2-690M), Android 6.0.1, CPU: Snapdragon 617 MSM8952, GPU: Adreno (TM) 510

around 250 ms
VLNQA00011, Xiaomi Mi 5s (MI 5s), Android 6.0.1, CPU: Snapdragon 820 MSM8996, GPU: Adreno (TM) 530

Note: The project brakes in 2018.4

  1. Resolution Note:

    Seems by design:

    " is reading the libsqlite3.so file every time a native function from it is used. From what I know there is no way to specify that a native binary should be loaded on startup"

    based on QA testing this is not correct cause the second call is sig. faster than the first one. Also it's expected that older phones are slower than desktop PCs.

Add comment

Log in to post comment

All about bugs

View bugs we have successfully reproduced, and vote for the bugs you want to see fixed most urgently.