I hadn’t considered the potential benefits of caching, which could indeed help performance significantly. However, I still believe it would be beneficial to allow the bases feature to operate directly with CSV or JSON files—including both reading and modifying them.
The requested feature would be valuable not only for handling large databases, but also because CSV and JSON—especially the former—are convenient and efficient formats for storing, visualizing, and modifying structured data.
The reason I want to use Obsidian is to take advantage of its other features—such as tags, links, and backlinks—to create a richer, more interconnected knowledge base.