视频1 视频21 视频41 视频61 视频文章1 视频文章21 视频文章41 视频文章61 推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37 推荐39 推荐41 推荐43 推荐45 推荐47 推荐49 关键词1 关键词101 关键词201 关键词301 关键词401 关键词501 关键词601 关键词701 关键词801 关键词901 关键词1001 关键词1101 关键词1201 关键词1301 关键词1401 关键词1501 关键词1601 关键词1701 关键词1801 关键词1901 视频扩展1 视频扩展6 视频扩展11 视频扩展16 文章1 文章201 文章401 文章601 文章801 文章1001 资讯1 资讯501 资讯1001 资讯1501 标签1 标签501 标签1001 关键词1 关键词501 关键词1001 关键词1501 专题2001
MongoDBTip:CreateShortFieldNames
2020-11-09 13:25:04 责编:小采
文档


MongoDB’s dynamic schema and document-based data structure offer a lot of flexibility in development, but it’s important to understand how your document construction can affect available memory in your application. It’s incredibly valua

MongoDB’s dynamic schema and document-based data structure offer a lot of flexibility in development, but it’s important to understand how your document construction can affect available memory in your application. It’s incredibly valuable to optimize storage size of your documents, and one easy way to do this is by shortening your field names.

MongoDB stores all field names in each BSON document. In most cases the space is inconsequential, but when your data set grows to include millions of documents (and potentially collections), the extra bytes in long field names can add up. If document or schema overhead is a significant concern, consider shortening your field names.

For example, instead of the field names in the following document:

{ first_name: ?“Joseph”, address: “345 Caroll Street” , telephone: “19176253475”}


Consider shortening the names to:

{ fname: ?“Joseph”, addr: “345 Caroll Street” , tel: “19176253475”}


The Use Case

One case where this might be useful is when you are logging real-time data points such as web stats. Here, you have many small documents being added every minute, second and hour of the day. You might have a document that looks like this:

{"_id" : "512d35b0400fed3b997cd9c9" ,
"hour" : "Thu Mar 05 2013 10:00:00 GMT-0500 (EST)" ,
"site" : "abc" , "u" : 1 ,
"pageviews" : 1}


Having longer field names could end up taking up a lot of disk space over time, while using shorter field names with have a larger impact on your disk savings. Consider cutting down your field names like so:

{"_id" : "512d35b0400fed3b997cd9c9" ,
"h" : "Thu Mar 05 2013 10:00:00 GMT-0500 (EST)" ,
"s" : "abc" , "u" : 1 ,
"pv" : 1}


Depending on your document size, using shorter field names will have a tangible benefit to your application.

  • Learn more about MongoDB for Analytics
  • Update: Here is a link to the two server tickets that are being worked on to optimize document storage at the database level.?

  • SERVER-863
  • SERVER-1
  • 下载本文
    显示全文
    专题