_idをObjectIDにするのが容量が少し小さくなるのは分かった。
Import速度も「id」をObjectIDにした方が少し早い。
(個人の感想です。)
| Collection | StorageSize | Index Size | Objects | lastExtentSize|時間|
| t_u_xxxxx | 118.18m | 8.67m | 279,767 | 35.88m |18秒|:_idをObjectIDにした
| t_u_xxxxx | 118.18m | 9.72m | 279,767 | 35.88m | 21秒|: _idをIntにした
Tue Feb 26 17:36:34 38700 12900/second
Tue Feb 26 17:36:37 11789661/41384982 28%
Tue Feb 26 17:36:37 79700 13283/second
Tue Feb 26 17:36:40 18608276/41384982 44%
Tue Feb 26 17:36:40 125800 13977/second
Tue Feb 26 17:36:43 22527263/41384982 54%
Tue Feb 26 17:36:43 152300 12691/second
Tue Feb 26 17:36:46 28148602/41384982 68%
Tue Feb 26 17:36:46 190300 12686/second
Tue Feb 26 17:36:49 34909096/41384982 84%
Tue Feb 26 17:36:49 236000 13111/second
Tue Feb 26 17:36:52 41360034/41384982 99%
Tue Feb 26 17:36:52 279600 13314/second
Tue Feb 26 17:36:52 imported 279767 objects
Tue Feb 26 17:57:11 37700 12566/second
Tue Feb 26 17:57:14 13105364/41384979 31%
Tue Feb 26 17:57:14 88600 14766/second
Tue Feb 26 17:57:17 16891567/41384979 40%
Tue Feb 26 17:57:17 114200 12688/second
Tue Feb 26 17:57:20 20338409/41384979 49%
Tue Feb 26 17:57:20 137500 11458/second
Tue Feb 26 17:57:23 23652004/41384979 57%
Tue Feb 26 17:57:23 159900 10660/second
Tue Feb 26 17:57:26 28414510/41384979 68%
Tue Feb 26 17:57:26 192100 10672/second
Tue Feb 26 17:57:29 32970858/41384979 79%
Tue Feb 26 17:57:29 222900 10614/second
Tue Feb 26 17:57:32 38888195/41384979 93%
Tue Feb 26 17:57:32 262900 10954/second
Tue Feb 26 17:57:32 imported 279767 objects
Import速度も「id」をObjectIDにした方が少し早い。
(個人の感想です。)
| Collection | StorageSize | Index Size | Objects | lastExtentSize|時間|
| t_u_xxxxx | 118.18m | 8.67m | 279,767 | 35.88m |18秒|:_idをObjectIDにした
| t_u_xxxxx | 118.18m | 9.72m | 279,767 | 35.88m | 21秒|: _idをIntにした
- CSV Import Log(_idをObjectIDにした)
Tue Feb 26 17:36:34 38700 12900/second
Tue Feb 26 17:36:37 11789661/41384982 28%
Tue Feb 26 17:36:37 79700 13283/second
Tue Feb 26 17:36:40 18608276/41384982 44%
Tue Feb 26 17:36:40 125800 13977/second
Tue Feb 26 17:36:43 22527263/41384982 54%
Tue Feb 26 17:36:43 152300 12691/second
Tue Feb 26 17:36:46 28148602/41384982 68%
Tue Feb 26 17:36:46 190300 12686/second
Tue Feb 26 17:36:49 34909096/41384982 84%
Tue Feb 26 17:36:49 236000 13111/second
Tue Feb 26 17:36:52 41360034/41384982 99%
Tue Feb 26 17:36:52 279600 13314/second
Tue Feb 26 17:36:52 imported 279767 objects
- CSV Import Log( _idをIntにした)
Tue Feb 26 17:57:11 37700 12566/second
Tue Feb 26 17:57:14 13105364/41384979 31%
Tue Feb 26 17:57:14 88600 14766/second
Tue Feb 26 17:57:17 16891567/41384979 40%
Tue Feb 26 17:57:17 114200 12688/second
Tue Feb 26 17:57:20 20338409/41384979 49%
Tue Feb 26 17:57:20 137500 11458/second
Tue Feb 26 17:57:23 23652004/41384979 57%
Tue Feb 26 17:57:23 159900 10660/second
Tue Feb 26 17:57:26 28414510/41384979 68%
Tue Feb 26 17:57:26 192100 10672/second
Tue Feb 26 17:57:29 32970858/41384979 79%
Tue Feb 26 17:57:29 222900 10614/second
Tue Feb 26 17:57:32 38888195/41384979 93%
Tue Feb 26 17:57:32 262900 10954/second
Tue Feb 26 17:57:32 imported 279767 objects
0 件のコメント:
コメントを投稿