Description:
-------**----------------------------
we developed react-native-windows app with react-native-sqlite-storage latest version. We observed that database operations such as select, insert, delete, update is taking more time when we compare with iOS and Android.
Example:
Query: select field1, field2 from tableName where Id='someId' (this query returns 46 records)
Windows-time-consumptions: In windows, its taking 120ms
iOS-time-consumption: In iOS, its taking 36ms
So from the above analysis, react-native-sqlite-storage is taking 3 times more time when compare to iOS to load the 46 records.
Looks like iOS uses SQLite3 but Windows uses winsqlite.
Expected Behavior:
We expect the same or less loading time for query execution.
Environment:
System:
OS: Windows 10 10.0.19043
CPU: (4) x64 Intel(R) Core(TM) i7-9750H CPU @ 2.60GHz
Memory: 2.87 GB / 5.98 GB
Binaries:
Node: 14.19.3 - C:\Program Files\nodejs\node.EXE
Yarn: Not Found
npm: 6.14.17 - C:\Program Files\nodejs\npm.CMD
Watchman: Not Found
SDKs:
Android SDK: Not Found
Windows SDK:
AllowDevelopmentWithoutDevLicense: Enabled
Versions: 10.0.18362.0, 10.0.19041.0, 10.0.20348.0
IDEs:
Android Studio: Not Found
Visual Studio: 16.11.32106.194 (Visual Studio Community 2019)
Languages:
Java: 18.0.1.1
npmPackages:
@react-native-community/cli: Not Found
react: 17.0.2 => 17.0.2
react-native: 0.67.3 => 0.67.3
react-native-windows: 0.67.2 => 0.67.2
npmGlobalPackages:
Description: -------**---------------------------- we developed react-native-windows app with react-native-sqlite-storage latest version. We observed that database operations such as select, insert, delete, update is taking more time when we compare with iOS and Android.
Example: Query: select field1, field2 from tableName where Id='someId' (this query returns 46 records) Windows-time-consumptions: In windows, its taking 120ms iOS-time-consumption: In iOS, its taking 36ms
So from the above analysis, react-native-sqlite-storage is taking 3 times more time when compare to iOS to load the 46 records.
Looks like iOS uses SQLite3 but Windows uses winsqlite.
Expected Behavior:
We expect the same or less loading time for query execution.
Environment:
System: OS: Windows 10 10.0.19043 CPU: (4) x64 Intel(R) Core(TM) i7-9750H CPU @ 2.60GHz Memory: 2.87 GB / 5.98 GB Binaries: Node: 14.19.3 - C:\Program Files\nodejs\node.EXE Yarn: Not Found npm: 6.14.17 - C:\Program Files\nodejs\npm.CMD Watchman: Not Found SDKs: Android SDK: Not Found Windows SDK: AllowDevelopmentWithoutDevLicense: Enabled Versions: 10.0.18362.0, 10.0.19041.0, 10.0.20348.0 IDEs: Android Studio: Not Found Visual Studio: 16.11.32106.194 (Visual Studio Community 2019) Languages: Java: 18.0.1.1 npmPackages: @react-native-community/cli: Not Found react: 17.0.2 => 17.0.2 react-native: 0.67.3 => 0.67.3 react-native-windows: 0.67.2 => 0.67.2 npmGlobalPackages: