For bases to work I need to split my stuff up into tiny documents but I'd prefer to have one big document with separate sections. For example I keep one document `book-recommendations.md` with many small sections for books I'd like to read. I can't search through that with bases unless I split those out into many small files in with one recommendation each.
I don't need entire files for each individual book/movie/task I want to manage.
They'll have maybe 4-5 properties at most with not much content in them.
File system, and syncing operations will take a massive hit if I have to manage that many files.
I'm a fan of Obsidian, not affiliated with them, but my experience with basic file syncing like syncthing or git is that you should be able to easily get up into the ten's of thousands of files without an issue.
I recently had to sync a new Obsidian vault from scratch, a vault with thousands of files, and it took minutes to complete because of this, even though most files are a couple of KB at most.
Easy to fix and low hanging fruit, but still an issue for us with many files in our vaults.
And it design for a big document, with many nodes in it, it will filter this nodes by tags and properties.