I know people hit the 10K really fast. 10K is the limit for which obsidian switches algorithms (personally, I don't understand how 10K db rows would be a problem, but ok).
It is very easy to run into 100k:
- external sources like the documentation for your programming languages, frameworks etc that come as markdown
- if you store every entity as a note, like you do with obsidian bases. Think task tracking, habit trackers, book collections
- clippings, daily notes, project notes, zettels etc
So if I would design a search improvement, I would test the 100k, 200k, 500k, 1m mark with synthetic data.
- external sources like the documentation for your programming languages, frameworks etc that come as markdown
- if you store every entity as a note, like you do with obsidian bases. Think task tracking, habit trackers, book collections
- clippings, daily notes, project notes, zettels etc
So if I would design a search improvement, I would test the 100k, 200k, 500k, 1m mark with synthetic data.