Hi Community,
I’m running into a performance issue while importing selective access for users.
Context
- List:
Product - Planning Node (~25,000 items) - Users: 150+ (many-to-many mapping—multiple users can share the same Planning Node access)
- Goal: Set up Selective Access (Read/Write) on the
Product - Planning Node list in the Users tab for all model users via recurring imports (full refresh). - Approach: Created a saved view as import source → Import to Users tab fields
Selective Access (Read) and Selective Access (Write).
Issue
- The import starts normally but consistently stalls around 73% during a full refresh.
- I’ve let it run for ~2 hours and it doesn’t complete. No explicit error message, it just “hangs.”
Questions for the Community
- Has anyone seen imports to the Users tab stalling (especially at a consistent percentage) when writing large volumes of selective access assignments?
- Are there known best practices for batching selective access loads for large lists (e.g., chunking by node subsets or by user groups)? What batch sizes have worked for you?
- Is a full refresh into Users the wrong pattern for this scale? Would you recommend a delta-based approach (e.g., maintain a users×node mapping module and only load changes) instead?
Any technical limits or caveats with Users tab imports that I should be aware of (e.g., memory pressure, locking, number of item assignments per import, throttling)?
