LowSkillDeveloper / 3WiFiLocator-Unofficial

Unofficial 3WiFi Locator for Android
Apache License 2.0
20 stars 2 forks source link

Long time adding to a local database when it already contains many rows (~50K+ rows) #12

Closed LowSkillDeveloper closed 7 months ago

LowSkillDeveloper commented 8 months ago

It takes a long time to add new data to the local database when importing, when it already contains many rows, for example, myuploads.txt was completely imported from 3wifi. When you try to import other wifi points, for example from json or the next batch of data from RouterScan, there is a check for duplicates and all rows in the database are checked, which can be 50K or even 200K.

LowSkillDeveloper commented 7 months ago

Fixed in https://github.com/LowSkillDeveloper/3WiFiLocator-Unofficial/commit/280d4b830d537aec4efdb150db7aacf9bcefdff9 and https://github.com/LowSkillDeveloper/3WiFiLocator-Unofficial/commit/eabf19d1c74617b7d9bd3ff9e0ee009e4c05c513