[badpun]

For one, with a 1 file per row (entity) design, any larger query would require reading from potentially millions of files, which I imagine would be nightmarishly inefficient.

[xyheme]

I think, unless column-oriented database is used, "one file per row" is similar to normal row-oriented database.

Maybe there are some benchmarks in the past.