I'm kinda wondering if there's just too many files.
The assets folder (and subfolders) contain in the realm of 50,000 files.
I'm wondering if it's the DB read...
I tried deleting 70% ish of the files and syncing it, and it loaded faster. I might try syncing it with all the files there and see how fast that loads.
Deleting them from the file system, or from the DB too?
from the file system. The sync should have removed them from the db right?
Yeah probably. I'm just wondering if the bottleneck is just in the DB call for the records or something SS does with the file system on load.
Is there a way to get distinct records using ORM?
Here is my code and want to apply distinct on MemberID field.