Updated on 2025-02-27 GMT+08:00

Selecting a Storage Model

During database design, some key factors about table design will greatly affect the subsequent query performance of the database. Table design affects data storage as well. Scientific table design reduces I/O operations and minimizes memory usage, improving the query performance.

Selecting a model for table storage is the first step of table definition. Select a proper storage model for your service based on the following table.

Storage Model

Application Scenario

Row store

Point queries (simple index-based queries that only return a few records)

Scenarios requiring frequent addition, deletion, and modification operations