Yeah, Danny O'Brien is a friend of mine, and we discussed the idea a bit at the time. I feel like it might be easier to not get lost with the file divided into units smaller than a megabyte though. Does org-mode scale up to files with 10,000 headings?
I suppose it is best to ask this in emacs-orgmode list.
Re: One Big Text File: About a decade ago I used it daily for everything for about a year or even longer. Strangely, it was actually working remarkably well. I like to think that over time it grows into a nice image of a person's brain. It is very flexible -- loosely structured "dump" where needed, and strictly structured on other places.
I abandoned it in favor of "one thought, one file" type of approaches, just out of curiosity, I guess; I was hoping to create a Zettelkasten That Works For Sure instead. But this never happened.
I still think One Big Text File a great, somewhat forgotten idea. It's easy to add some structure to everyday use with scripting/grep, turning it into a loosely structured database of sorts. I did less of that at the time than I initially imagined myself doing, though.
Is One Big Text File somewhat forgotten? I think of it as being pretty prevalent, maybe more so now than before, now that org-mode is in such wide use.