nendo 5bb10dacd1 SaveSync: paginate recompute task scan by primary key ...

get_all_saves() materialized every Save row across all users into a
single .all() list. On instances with very large libraries that's a
real RAM ceiling and pins every row for the lifetime of the recompute
run.

Replace it with get_saves_after_id(after_id, limit) and have the
recompute task drive keyset pagination in PAGE_SIZE-row chunks. SQLAlchemy
streaming via .execution_options(yield_per=...) is incompatible with the
per-call session lifetime that @begin_session enforces (the session
exits before the consumer iterates), so keyset paging from the caller is
the cleanest fit.

Behavior is unchanged: same row coverage, same idempotency, same
counters. Memory usage drops from O(all saves) to O(PAGE_SIZE).

2026-05-29 17:38:49 +09:00

..

cleanup_missing_roms.py

some changes from review

2026-03-10 16:13:21 -04:00

cleanup_orphaned_resources.py

fix cleanup orphaned resources

2026-05-18 20:30:18 -04:00

recompute_save_content_hashes.py

SaveSync: paginate recompute task scan by primary key

2026-05-29 17:38:49 +09:00

sync_folder_scan.py

refactor(filesystem): lazy-init launchbox + sync handlers, drop tolerate_missing_base

2026-05-24 14:59:03 +00:00