citomcclure
commented
1 month ago Using DynamoDB scan operation for search is costly and inefficient, especially with larger tables. In our case, since we need to filter the scan down to a specific user's notes to search, we will be scanning the full table even though the vast majority of that scan (when we have multiple users) will not be used as part of the search.
Best implementation will require storing data in another search service and querying on that.
See here for in depth conversation
User Story
As a user, I want to search across all my notes so that I can find relevant notes quickly.