Skip to content

Move SyncNotes loop to the db #1871

@TomasArrachea

Description

@TomasArrachea

Currently the Store component implements the sync_notes by making multiple select_notes_since_block_by_tag_and_sender queries while the payload limit is not exceeded. We should move the loop to the DB to return multiple matching blocks instead of just the first matching one, avoiding the queries overhead. Additionally, the method currently takes a list of account_ids that is not being used so could be removed.

Context: #1843 (comment) and #1843 (comment)

Metadata

Metadata

Assignees

No one assigned

    Labels

    storeRelated to the store component

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions