Shulou(Shulou.com)06/01 Report--

[problem description]

1. After the 2300m csv file was imported into the database, 4880m space was used. What is the reason?

2. The 4880m space is roughly divided into half of the data file space and half of the index file space. Why does the index file occupy such a large space?

[solution]

1. Because Sequoiadb stores data in bson structure, compared with csv structure, there are more key and data type information, so bson structure storage needs more storage space.

2. When the csv file is imported into Sequoiadb, an oid is also generated, which is the only index by default. Sequoiadb stores the data file and the index file separately, so it is divided into these two parts in space, and the space size of the index file is related to the specific index record.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.