Little Light is an inventory manager/companion app for Destiny 2 for both iOS and Android. It helps guardians move their gear and track their ingame progress.
Here are some test results full scanning the InventoryItem manifest on a newer and old and slow phone. Here are the tests:
Test 1: Full scan manifest and checking each row for fragments and aspects
Test 2: Using LIKE keyword so db will find rows with fragments by pattern match
Test 3: Using LIKE keyword with 2 patterns to find both fragments and aspects
I have also added a method to get hashes from db tables using a pattern match. A dev tools button was added to use it to get the hashes for tracker socketTypes.
Devices:
iPhone 6 plus, released 9/2014 (8.5 yrs old)
iPhone 11 pro max, released 9/2019 (3.5 yrs old)
iPhone 6 plus (18 sec to load manifest)
flutter: Test #3 scanned 119 rows, found 119 items in 8999 ms
flutter: Test #2 scanned 71 rows, found 71 items in 8227 ms
flutter: Test #3 scanned 119 rows, found 119 items in 10824 ms
flutter: Test #3 scanned 119 rows, found 119 items in 10761 ms (after phone restart)
flutter: Test #1 scanned 21661 rows, found 119 items in 16965 ms
flutter: Test #1 scanned 21661 rows, found 119 items in 12680 ms
flutter: Test #3 scanned 119 rows, found 119 items in 5040 ms
flutter: Test #1 scanned 21661 rows, found 119 items in 12409 ms
flutter: Test #1 scanned 21673 rows, found 119 items in 15462 ms
flutter: Test #1 scanned 21673 rows, found 119 items in 16530 ms
flutter: Test #2 scanned 71 rows, found 71 items in 10229 ms
flutter: Test #3 scanned 119 rows, found 119 items in 10854 ms
iPhone 11 pro max
flutter: Test #1 scanned 21661 rows, found 119 items in 3622 ms
flutter: Test #3 scanned 119 rows, found 119 items in 1167 ms
flutter: Test #1 scanned 21661 rows, found 119 items in 2673 ms
flutter: Test #1 scanned 21661 rows, found 119 items in 3743 ms (after phone restart)
flutter: Test #1 scanned 21673 rows, found 119 items in 3366 ms
flutter: Test #3 scanned 119 rows, found 119 items in 1341 ms
flutter: Test #1 scanned 21673 rows, found 119 items in 3434 ms (after phone restart)
Here are some test results full scanning the InventoryItem manifest on a newer and old and slow phone. Here are the tests: Test 1: Full scan manifest and checking each row for fragments and aspects Test 2: Using LIKE keyword so db will find rows with fragments by pattern match Test 3: Using LIKE keyword with 2 patterns to find both fragments and aspects
I have also added a method to get hashes from db tables using a pattern match. A dev tools button was added to use it to get the hashes for tracker socketTypes.
Devices:
iPhone 6 plus, released 9/2014 (8.5 yrs old) iPhone 11 pro max, released 9/2019 (3.5 yrs old)
iPhone 6 plus (18 sec to load manifest) flutter: Test #3 scanned 119 rows, found 119 items in 8999 ms flutter: Test #2 scanned 71 rows, found 71 items in 8227 ms flutter: Test #3 scanned 119 rows, found 119 items in 10824 ms flutter: Test #3 scanned 119 rows, found 119 items in 10761 ms (after phone restart) flutter: Test #1 scanned 21661 rows, found 119 items in 16965 ms flutter: Test #1 scanned 21661 rows, found 119 items in 12680 ms flutter: Test #3 scanned 119 rows, found 119 items in 5040 ms flutter: Test #1 scanned 21661 rows, found 119 items in 12409 ms flutter: Test #1 scanned 21673 rows, found 119 items in 15462 ms flutter: Test #1 scanned 21673 rows, found 119 items in 16530 ms flutter: Test #2 scanned 71 rows, found 71 items in 10229 ms flutter: Test #3 scanned 119 rows, found 119 items in 10854 ms
iPhone 11 pro max flutter: Test #1 scanned 21661 rows, found 119 items in 3622 ms flutter: Test #3 scanned 119 rows, found 119 items in 1167 ms flutter: Test #1 scanned 21661 rows, found 119 items in 2673 ms flutter: Test #1 scanned 21661 rows, found 119 items in 3743 ms (after phone restart) flutter: Test #1 scanned 21673 rows, found 119 items in 3366 ms flutter: Test #3 scanned 119 rows, found 119 items in 1341 ms flutter: Test #1 scanned 21673 rows, found 119 items in 3434 ms (after phone restart)