We stress tested against 20k Markdown files (found here: https://github.com/Zettelkasten-Method/10000-markdown-files), and it works okay on a relatively fast desktop computer. We’ve done extensive optimization on file explorer and search, but the initial loading and processing could take some time for sure.
Haven’t seen real-world cases that would require more, unless you want to for example display Wikipedia inside Obsidian.