[drop_suggestions](https://github.com/mozilla/application-services/blob/71578bea70b5f9da0b9c35c17e8fe15e9cf2ebc9/components/suggest/src/db.rs#L947) is called for each record in the database, which I think is around 50 or so. None of these tables have an index on `record_id`, which means SQLite needs to do a table scan to delete the rows. I think the suggestions table can contain around 10,000 suggestions. IOW, this might be slow and should be sped up using an index. Both the Android and iOS teams have noticed some performance issues (TODO: link to them) and this *might* be contributing to those.
Bug 1900837 Comment 0 Edit History
Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.
[drop_suggestions](https://github.com/mozilla/application-services/blob/71578bea70b5f9da0b9c35c17e8fe15e9cf2ebc9/components/suggest/src/db.rs#L947) is called for each record in the database, which I think is around 50 or so. None of these tables have an index on `record_id`, which means SQLite needs to do a table scan to delete the rows. I think the suggestions table can contain around 10,000 suggestions. IOW, this might be slow and should be sped up using an index. Both the Android and iOS teams have noticed some performance issues and this *might* be contributing to those.
[drop_suggestions](https://github.com/mozilla/application-services/blob/71578bea70b5f9da0b9c35c17e8fe15e9cf2ebc9/components/suggest/src/db.rs#L947) is called for each record in the database, which I think is around 50 or so. In practice, this seems to be running slow and we should speed it up. This is probably causing the performance issues that the Android team has noticed and *might* be contributing to the iOS issues as well.