Hi all,
I'm looking for advice or proven patterns to avoid performance bottlenecks when using the SAS Annotations service to implement tagging in a large AgGrid table.
Background:
With the Migration Manager team at SAS, we often upload and manage thousands of inventory items at a time. We’re working on a redesign that will allow users to add and view annotations/tags for each item in the AgGrid table. Each item is uniquely identified by a resourceId, and tags are associated with items using the SAS Annotations service.
The Challenge:
A naive implementation would require an API call per row (i.e., per resourceId) to fetch the tags for each item. For thousands of items, this quickly becomes a performance and scalability issue.
Question:
Has anyone solved this, or encountered similar large-scale tagging/annotation scenarios?
What are the best practices or recommended workarounds to efficiently display (and possibly filter/search) tags for each row in a large data grid, without overwhelming the backend with API calls?
For example, is there a proven batching, caching, or denormalization strategy that works well with the annotations service, or other architectural approaches we should consider?
Any insight, tips, or links to example architectures or code would be greatly appreciated!
