search

andpor / react-native-sqlite-storage

Full featured SQLite3 Native Plugin for React Native (Android and iOS)
MIT License
2.75k stars 521 forks source link

Storage Limit #506

Open alexkendall opened 2 years ago

alexkendall commented 2 years ago

Is there a storage limit for this library?

Currently coming across some issues with a very large query. The app works fine for smaller queries.

Gavin-PunchCard commented 2 years ago

I'm not sure on limits, but we've had to break large queries into smaller groups. For example one of our queries is 275k records and we break it into 20k groups. A few other threads mention 50k groups as well.

Recently we've switched hermes on in our react-native project and found that our execution time went up 4x. No idea if this is applicable to what you're working on, but it's an issue we're currently trying to work through.

sjt145 commented 2 years ago

Hey @Gavin-PunchCard , Can you share some code on how did you break large queries into smaller groups?

It will be really helpful